August 24, 2007 at 1:34 pm
Newbie to SQL2005 and SSIS needs help....
I created a SSIS package using the Import/Export wizard from Management Studio. I now need to edit that package, specifically needing to remove some of the tables from it. However, I can't find where in the package the tables are even listed! I've gone into the edit/properties box on each task created by the wizard, but can't find what I'm looking for anywhere.
Can anyone tell me where I should be looking for this info?
August 26, 2007 at 7:48 am
You will need to open SQL Server Business Intelligence Development Studio (the link comes from the SQL Server 2005 program group). From there open the project where ever you have it saved. Select the Data Flow task from the Control Flow tab. Click the Data Flow tab. You will see the tables there. Select the ones you do not want and click delete.
August 27, 2007 at 9:40 am
I actually did that, but there are no data flow tasks listed. It just says "No data flow tasks have been added to this package. To add one...." So I figured it must be in one of the control flow tasks, but so far I've had no luck finding anything...
June 9, 2009 at 12:47 pm
I had similar issue and I found that in my case, it was due to the fact that SQL 2005 automatically checkmarks "Optimize for many tables" if you select more than 20 tables in the wizard while creating dtsx.
When that happens, nothing comes up in the "Data Flow" in SSBI Studio. And in the "Control Flow" It shows some crappy stuff like "NonTransactableSql", "Start Transaction", "PrologueSql" and so on.
The resolution for me was to uncheck the "Optimize for many tables" while creating dtsx, then the tables could be seen in the "Data Flow" section.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply