Viewing 15 posts - 1,246 through 1,260 (of 3,232 total)
MTY (7/30/2009)
How I can read my values from the Flat File in my second Data Flow ?
The same way you do in the first data flow, use a Flat...
July 30, 2009 at 3:18 pm
abhisek karki (7/30/2009)
July 30, 2009 at 3:16 pm
abhisek karki (7/30/2009)
I removed the flat file destination from my data flow, so i route error output to row count, but it didnt give me the # if error...
July 30, 2009 at 3:13 pm
abhisek karki (7/30/2009)
July 30, 2009 at 3:00 pm
What does the execution plan look like?
July 30, 2009 at 2:47 pm
Here's an idea:
From your error output, route that to a Row Count transformation. This will give you the # of error rows in the pipeline. From there, add...
July 30, 2009 at 2:44 pm
Were you ever able to connect?
It sounds like you'll need to get someone involved who has server admin rights to help go through the troubleshooting list.
July 30, 2009 at 2:29 pm
Another one from Microsoft:
July 30, 2009 at 2:18 pm
Try to walk through this and see what happens:
http://totaldevpro.com/blogs/khaselden/archive/2009/04/09/connecting-to-a-remote-ssis-server.aspx
July 30, 2009 at 2:16 pm
Are you trying to connect via SSMS? What happens?
July 30, 2009 at 2:11 pm
You are using SSIS for this, right?
If so, each iteration of your for each loop should process one file. In your data flow for the file, you can use...
July 30, 2009 at 12:18 pm
Yes. If you go back to my detailed post, you'll see that I discussed using Lookup transformations in place of the joins to get the values from MSO and...
July 30, 2009 at 11:22 am
It looks like you guys start a bit earlier in the AM than I :-).
You're SSIS work is close. You need 2 data flows. The first...
July 30, 2009 at 9:26 am
Another alternative would be to use SSIS to import and validate your files prior to loading them in your database.
July 29, 2009 at 11:52 am
Viewing 15 posts - 1,246 through 1,260 (of 3,232 total)