|
|
Posted by Erland Sommarskog on 08/08/06 21:39
Ted (r.ted.byers@rogers.com) writes:
> To deal with the quotes (because your example doesn't show what happens
> if the first column in the file is quoted text), I tried the data
> import wizard from within SQL Server Management Studio. For most of
> the data files/table combinations, it worked well. However, there are
> issues, especially related to nulls.
Wait a minute, last night you were using BULK INSERT, now you are using
the Import Wizard which uses SQL Integration Services that I know next
to nothing about. So I cannot assist with that part.
> 4) Each time I tried the wizard, I told it to store a package on the
> server. However, I can't seem to find these packages. Where should I
> be looking for them, and can I tell SQL Server Management Studio to
> export the packages as scripts I can invokve from the commandline?
As I understand it, Mgmt Studio does not offer any interface to
Integration Services. To this end you should use Business Intelligence
Development Studio.
> I solved the problem with errors (item #1 in my previous post) by more
> carefully specifying the data type of the input file columns. But this
> leads to an equally serious problem. All the nulls in that column are
> silently converted into zero.
Just a stupid check: you don't happen to have a default of 0 on those
columns.
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|