Viewing 15 posts - 616 through 630 (of 3,232 total)
I see room for improvement here in several places.
First, you've got to use constraints and indexes in your table design. Even if you get this working, you'll...
March 19, 2010 at 12:11 pm
Yes, package variables are user variables. Sorry for the confusion.
Like I said in my first reply, you'll have to set the Connection String property to embed the...
March 19, 2010 at 10:29 am
I usually default the variable values to my test DB. This allows the package to pass validation instead of failing as it does before the variables are populated.
March 18, 2010 at 1:28 pm
Each iteration of your loop will grab the connection info for the current connection and set the package level variables. When the ole db connection manager is invoked during...
March 18, 2010 at 12:26 pm
Why not use a data flow task?
March 18, 2010 at 12:16 pm
Instead of defining expressions for the individual elements of the connection, set all of the dynamic connection properties using the connectionstring property. Here you can set server, user, password,...
March 18, 2010 at 12:08 pm
March 18, 2010 at 12:06 pm
Steve Jones - Editor (3/18/2010)
We are expecting 5" of snow here, which makes my word for today "Noooooooooooooooooooooooooooo"This is likely to mess up my Ski Friday.
Does Ski Friday not require...
March 18, 2010 at 11:15 am
Partitioning can improve performance; however, 3 million rows in a table should not put you in a situation where your queries are timing out. I would not partition a...
March 18, 2010 at 9:46 am
Your like a mind reader Gus. That's exactly where I was headed. I was hoping to see the OPs existing DDL so we can help further. From...
March 16, 2010 at 11:55 am
This numbering system generated from a stored procedure provides all types of information at a glance as well as provides a unique ID used in other tables.
I'll have to admit...
March 16, 2010 at 11:23 am
Trace your SQL instance and find out what the SQL statement coming from the source adapter looks like.
March 15, 2010 at 3:54 pm
To improve on your 15 hour process, I think we need to know a bit more about it. Can you give us an explanation of how you are 1)...
March 15, 2010 at 3:49 pm
Viewing 15 posts - 616 through 630 (of 3,232 total)