November 27, 2006 at 4:48 am
I have an odd problem that occurs almost every time I execute a SSIS package in Visual Studio on my local workstation. Not every time but around 80-90 % of the times.SSIS Project description:I have a SSIS project with a master package and 10 child packages. The master package executes each child package in sequence. Each child package selects data from a DB2 datasource and stores it in a flatfile. For DB2 connectivity, I am using the "IBM OLE DB Provider for DB2" from IBM.Problem:When I get to the point in my package to execute the first Data Flow Task in my first child package, the SQLDumper window is opened and immediately closed and then the package execution stops. Visual Studio still shows package step in yellow, which means that it is still running. There is no error information in the Progress tab. Thanks for any guidance,Ola
November 30, 2006 at 8:00 am
This was removed by the editor as SPAM
February 28, 2007 at 3:40 pm
I have the same problem. It seems to be related to creating a managed connection to DB2. For me the problem seems to go away (only some times) if I run the package by hitting ctrl+F5 i.e. not in debug mode. I have tried everyting reinstalling the IBM drivers to reverting back to an older version and nothing seems to be working. I am not sure if it is just a one off issue because of some conflicting Dlls. Were you able to make a headway into this issue?
February 28, 2007 at 8:52 pm
I had the same problem.
The OLEDB driver provided by IBM is bugged.
We use Microsoft's now.
Leonce
March 1, 2007 at 9:35 am
Yes. We too switched to Microsoft. No problems ever since. (The driver is slower though. At least when previewing data.)
Ola
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply