Viewing 15 posts - 796 through 810 (of 3,232 total)
Yep, you are correct. I mis-stated this as it should have read : "This has been re-posted, please.....".
January 5, 2010 at 1:52 pm
Can you tell us what you plan to do with the rows inside the recordset?
The Recordset destination was not designed to pass data between tasks. Use the Raw File...
January 5, 2010 at 1:41 pm
First off, you won't need a cursor for this. Secondly, I'm not sure I follow what you want to do with the duplicate rows. Can you give an...
January 5, 2010 at 1:29 pm
No problem. Read through the article, give it a shot, and then post back with your results. If we need to work through it, we will; otherwise, it will...
January 5, 2010 at 1:26 pm
The Execute SQL task can be a bit tricky to work with when you are trying to return values back into variables. Everything has to be set up just...
January 5, 2010 at 1:21 pm
Gordon,
SSIS is so metadata dependant that any change to a data source that would result in a metadata change is going to cause problems. Outside of using a...
January 5, 2010 at 1:01 pm
wwei is right on. The ConnectionString property of the flat file connection manager object represents the path and file name. Setting this property, whether you use one or...
January 5, 2010 at 12:48 pm
You'll need to use dynamic SQL to get this to work with a parameterized directory path. Look up EXEC(@sql) in BOL for specifics. Basically, you'll need to build...
January 5, 2010 at 12:40 pm
This is a repost, please continue thread and responses here:
http://www.sqlservercentral.com/Forums/Topic842291-149-1.aspx?Update=1
January 5, 2010 at 12:28 pm
By the way, this is the exact same response you got the last time you posted this very question.
http://www.sqlservercentral.com/Forums/Topic834653-338-1.aspx
Please do not double post. Most of the regular...
January 5, 2010 at 12:27 pm
There are a few ways to do this. I'll explain the simplest way in detail and give you a brief expalation of other options.
The simplest way to do this...
January 5, 2010 at 12:06 pm
I think I'm going to Rue getting into this one...
January 4, 2010 at 4:47 pm
Are you guys planning on doing this until you've used Allspices?
January 4, 2010 at 4:15 pm
Also, based on the example you've given, it looks like you want to get the first inserted value from Table2. Yet, as you've shown, Table2 is a heap w/o...
January 4, 2010 at 3:58 pm
What happens when Table2 does not have a non-NULL value for v_ID, then what do you want to see?
January 4, 2010 at 3:47 pm
Viewing 15 posts - 796 through 810 (of 3,232 total)