Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: janetbarnett99
- Order by date
-
SSIS flat file import help!
If this is helpful to anyone, here goes: Tried to go through the virtual lab for ssis on the MS site, but, unfortunately, got to page 7 of 15 and there are no objects in the toolbox on the virtual lab, so I had to quit. Moved two of the dts to bulk imports for flat file imports and that's fine...- janetbarnett99
- Post #4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS flat file import help!
Thanks - I installed sp1 on my local machine. Now the error is a truncation error. However, I'm using the wizard (it's a very simple import, like my brain), using the advanced setting and asking sql to suggest types, and getting the following error. But what doesn't make sense to me is that...- janetbarnett99
- Post #3
- Forum: Microsoft SQL Server: Integration Services (SSIS)
-
SSIS flat file import help!
Boy, do I need HELP! Have a simple csv file that I need to import. Worked fine in sql2000; I put it into dts to execute on a monthly basis. Makes connection, db connection, table creation fine, but stops at validation of flat file? Basically, I want to go out and get a flat file, drop the...- janetbarnett99
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Integration Services (SSIS)
