Viewing 15 posts - 11,971 through 11,985 (of 13,876 total)
Looks like you are running that code for every row in your pipeline and then assigning a single result - presumably based on the values in the last row in...
July 27, 2010 at 10:36 am
Define your flat file source to be fixed width (not CSV). Then define your fields based on start pos / length etc - haven't done it for ages, so can't...
July 27, 2010 at 7:22 am
So you want the same value in every row?
That's fairly easy - here's how.
Create a package scope integer variable to hold the count.
Create an Execute SQL task to run the...
July 27, 2010 at 4:00 am
Please provide more detail - your requirement is difficult to understand. An example would help.
July 27, 2010 at 2:18 am
Have a look at the MERGE JOIN transformation - maybe that can do what you need. Difficult to know for sure without seeing examples of your data.
July 27, 2010 at 2:17 am
This thread looks very similar to this one:
http://www.sqlservercentral.com/Forums/Topic955373-148-1.aspx#bm955545
Why are you asking the same, or nearly the same, question again? What was wrong with the solutions proposed?
July 26, 2010 at 3:36 am
Looks to me like your delete query is not sophisticated enough and will leave behind orphaned records - except your referential integrity rules are currently stopping that. Be careful.
July 26, 2010 at 3:03 am
niffer76 (7/23/2010)
July 23, 2010 at 9:21 am
You'll need three dataflow tasks.
That does not mean that you need three packages. You can chain from one DF to another, or run them in parallel, within the same package.
July 21, 2010 at 12:50 pm
deepthiponguleti (7/20/2010)
I cannot make any changes to the insert stmts send to me by the vendor. I cannot add any stmt before or after the insert stmts.
Are you saying that...
July 20, 2010 at 12:26 pm
That article refers to an import to SQL Server, not an export to Excel.
Can you try explaining what's going on?
July 20, 2010 at 12:20 pm
I don't see how - that expression looks only at the first letter of [Copy of Description] whereas your query does much more.
To me, yours looks equivalent to this:
(SUBSTRING([Copy of...
July 20, 2010 at 9:07 am
Try using the import / export wizard.
July 20, 2010 at 7:44 am
What was the query and what was the error?
Are you using DB2 syntax or T-SQL syntax?
July 20, 2010 at 7:43 am
Viewing 15 posts - 11,971 through 11,985 (of 13,876 total)