troubleshooting Question

SSIS ETL Problems

Avatar of healthcheckinc
healthcheckincFlag for United States of America asked on
Microsoft SQL ServerMicrosoft SQL Server 2005
11 Comments1 Solution2138 ViewsLast Modified:
I am trying to take 2 flat files. The first has an accountID and alot of demographic information. There should be no duplicates in the file or in the table thaty I am eventually inserting into. The second file, is more of a detail file tha has multiple accountIDs and only a couple of columns that hold codes associated with the accountID. Pretty much a Main table(No dups) and a Description table(multiple accountIDs)...Anyhow, what I tried was to make 2 flatfile connections then connected a sort data flow, with only the Main table sort with the Remove duplicates checked. My next data flow object was a Merge Join with an Inner Join  and the selected fields I want to be put in my table. Then I added an OLEDB Destination(SQL Server 05) and thats it. Seems simple. My first error was
[Flat File Source 1 [1072]] Error: The column delimiter for column "BATCH DATE" was not found.
[Flat File Source 1 [1072]] Error: An error occurred while skipping data rows.
Then a bunch of Pipeline errors.

It really isnt a complex process Im trying to do but I am new to SSIS and I would almost rather write the SQL but I gotta start learning this stuff so any help would be greatly appreciated

I have added a file with the errors on it....HELP!!!!!!!!!!!!
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 11 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 11 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros