Viewing 15 posts - 12,436 through 12,450 (of 13,876 total)
stricknyn (11/20/2009)
Hi CrazyRoc,
...
Wow, you just got a cool new name! 😀
November 20, 2009 at 1:09 pm
Well done on solving that one by yourself. My solution would have worked too though - at no point did I mention deleting dups, all I said was 'processing' them,...
November 19, 2009 at 2:26 pm
A variant of the temp table method is probably still the easiest for you.
Bring all the data into a temp table, run a query to identify & process the dups...
November 19, 2009 at 11:40 am
I think you might need to MULTICAST to enable the 'reuse' you are after ...
November 19, 2009 at 8:45 am
This sounds like a pure SQL question, not SSIS? Anyhow, there is a way, using Common Table Expressions (or CTEs).
Using your example, it would be something like:
With Data as
(select productname,...
November 18, 2009 at 3:19 pm
omhoge (11/18/2009)
...wow, that was fun ...
I think I detect a hint of sarcasm 🙂
November 18, 2009 at 5:50 am
Good luck - please post back if you find the solution.
November 18, 2009 at 1:53 am
Assuming that the two tables are both in SQL Server already, just use an EXECUTE SQL task containing the relevant UPDATE command ... Seems a bit too easy - am...
November 17, 2009 at 1:57 pm
Are you able to rename the dtsx file from Windows Explorer? We need to find out whether the problem is with the package file itself, or with a file that...
November 17, 2009 at 7:22 am
Maybe it would help people here if you could post the code fragment which generates the error.
November 17, 2009 at 4:43 am
I've found the following suggestions - just quoting what I've found, no guarantees.
1) Install SP2 of SQL Server 2005
2) Register "(path)\Program Files\Microsoft SQL Server\90\DTS\Binn\DtsConn.DLL" using RegSvr32.exe.
November 17, 2009 at 2:21 am
That's nothing. You should see me with a hangover:-)
November 10, 2009 at 5:17 am
Yes - you can assign the result of an execute SQL task such as
SELECT COUNT(ID) FROM TABLE
directly to a variable.
November 9, 2009 at 9:40 am
Viewing 15 posts - 12,436 through 12,450 (of 13,876 total)