Viewing 15 posts - 9,076 through 9,090 (of 11,678 total)
Gianluca Sartori (8/2/2011)
Ninja's_RGR'us (8/2/2011)
Jack Corbett (8/2/2011)
August 2, 2011 at 7:05 am
Well, I don't know your environment of course, but you mentioned that the package only hangs when other processes have been running prior to the SSIS package. Maybe some of...
August 2, 2011 at 6:58 am
Mark Jerrom (8/2/2011)
I wonder why it'll work that way but not through the way you'd expect?
I have no idea. BIDS can sometimes be a pain in the *ss. 🙂
August 2, 2011 at 6:57 am
If you go to the OLE DB Destination properties (F4), can you set the AccesMode property to "OpenRowset using Fast Load"?
August 2, 2011 at 6:45 am
Are there any other expressions? Maybe on the OLE DB Destination itself?
Are you sure the second Destination is an OLE DB Destination? And you are using an OLE DB connection...
August 2, 2011 at 5:46 am
splinter-740692 (8/2/2011)
Note: The user account has full privileges (SYSADMIN) on the PROD server. So...
August 2, 2011 at 5:45 am
At first sight there isn't anything wrong with that expression.
The only difference that I say between those two OLE DB Destinations is the table name.
In the first it uses square...
August 2, 2011 at 5:23 am
splinter-740692 (8/2/2011)
Yes, i use the same dtsconfig file, referred through package configuration option in SSIS menu
OK. How does the package run on the server? Is it started by a SQL...
August 2, 2011 at 5:21 am
splinter-740692 (8/2/2011)
Correct. it works fine when open the same package through BIDS.
In BIDS, do you use the same configuration as on the server?
August 2, 2011 at 5:16 am
The icon is actually good. It is a notification from BIDSHelper to indicate that the connection manager is configured by an expression.
Can you post the expression here?
August 2, 2011 at 5:14 am
What happens when you open the package in BIDS? Does the validation succeed?
August 2, 2011 at 5:12 am
I use configurations on my connection managers all the time, and the fast load option never dissappears.
It sounds really strange to me, as the OLE DB Destination and the connection...
August 2, 2011 at 4:12 am
Do you run the entire package, or just a single task by right clicking on it and selecting "Execute Task"?
August 2, 2011 at 4:08 am
Maybe you have permission problems?
Are you running the package manually or on the server?
August 2, 2011 at 4:06 am
Viewing 15 posts - 9,076 through 9,090 (of 11,678 total)