Showing posts with label import. Show all posts
Showing posts with label import. Show all posts

Tuesday, March 20, 2012

Quoted Field and Escape Character Issue

I am attempting to import a flat file and have come accross and issue that I do not know how to fix in SSIS. The issue is that some of the text fields use quoted identifiers. This is not an issue in itself. The problem is they also use quotes as escape character if quotes are on the field.

So I see instances of "" because inside the quoted field is a quote. How do i specify an escape character?

Unfortuanately, the current Flat file parser does not know how to parse embedded qualifiers.

As a workaround, you should probably keep the qualifiers in the flat file source and process them downstream using either the script component or Derived Column.

Thanks.

Quickest way to show table relationships

Heard that VISIO allows you to import tables and it will
build a schema for you, is this true? Absent other
design tools besides SQL, is there another way that's user
friendly?This is a multi-part message in MIME format.
--=_NextPart_000_005E_01C34C53.29978BE0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Just create a database diagram in Enterprise Manager and include all =tables.
-- Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Janice J. Bush" <jbush@.stinsonmoheck.com> wrote in message =news:0ae401c34c73$7e6abbe0$a501280a@.phx.gbl...
Heard that VISIO allows you to import tables and it will build a schema for you, is this true? Absent other design tools besides SQL, is there another way that's user friendly?
--=_NextPart_000_005E_01C34C53.29978BE0
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
&

Just create a database diagram in =Enterprise Manager and include all tables.
-- Tom
---T=homas A. Moreau, BSc, PhD, MCSE, MCDBASQL Server MVPColumnist, SQL =Server ProfessionalToronto, ON Canadahttp://www.pinnaclepublishing.com/sql">www.pinnaclepublishing.com=/sql
"Janice J. Bush" =wrote in message news:0ae401c34c73$7e=6abbe0$a501280a@.phx.gbl...Heard that VISIO allows you to import tables and it will build a schema =for you, is this true? Absent other design tools besides SQL, is =there another way that's user friendly?

--=_NextPart_000_005E_01C34C53.29978BE0--

Wednesday, March 7, 2012

Quick Import Wizard Question - Importing XML Data

Hello,

I want to import some XML data from the internet. For example, http://www.somexmldata.com/ returns some well formatted XML data that I want to import into SQL Server 2005.

If I create an Integration Services Project it's easy - I use an 'XML Source' and specify the URL as the 'XML location'. Job done!

However, I want to do it using the Data Import Wizard - how do I accomplish the same thing?

Many thanks,
BenUnfortunately, we were not able to add support for XML sources to the Import Wizard.

That is something that should be part of our upcoming work.

You are welcome to request that at the product feedback site.

Quick DTS import question

I did a DTS import in SQL Server and it said that it failed to copydata between sql server to sql server, but when I do some basicrowchecks and run the application that uses the db, it appears that itdid in fact copy all the data. I noticed that the mdf and ldffiles are smaller than the source db, but I know this is common for anldf? Is it common for an mdf to shrink during dts? Can Idisregard that DTS wizard error since it appears the data was copiedover?

thanks!Run SELECT * against the tables in Query Aanalyzer and click on show results in a grid before execution to verify the move before ignoring the error. Hope this helps.|||Thanks - I'll give it a shot!