Viewing 15 posts - 1,366 through 1,380 (of 3,232 total)
Your UPDATE statement is written to where it would update the entire wce_contact table if your sub-select returns a rowcount > 0.
Can you post your table DDL for wce_contact? ...
June 29, 2009 at 10:09 am
So you have CSV files that were generated from some source that you want to import into a SQL Server instance using SSIS. Are all of the CSV files...
June 29, 2009 at 10:04 am
Have you looked into Package Configurations?
June 29, 2009 at 9:48 am
Let's see if we can get Steve's take on that question.
June 26, 2009 at 9:29 am
dave (6/25/2009)Needs a little more work first, but once I have some better error handling I'll probaly stick it up on a site for sharing.
Or maybe document it in an...
June 25, 2009 at 9:27 am
Where is it getting the table name from? It looks like you've got double quotes in the table name.
June 23, 2009 at 3:25 pm
So if you set up an OLE DB connection in SSIS and use the 'Test Connection' button, does it connect?
ODBC may work, but you may find it to be a...
June 23, 2009 at 9:48 am
Phil Parkin (6/22/2009)
jreece (6/22/2009)
John,--
I am now going to add a few derived columns - I thought "Create_Date" and "Change_Date" might be very useful for tracking updates.
You might also consider doing...
June 23, 2009 at 9:42 am
jeffrey yao (6/20/2009)
Michael Valentine Jones (6/18/2009)
Matt Miller (6/18/2009)
..."What is normalization and why is it important?"...
Just say that “normalization” is theoretical nonsense that so-called gurus like Date and Celko throw around...
June 22, 2009 at 4:42 pm
Peter, have you tried using the file system task with the copy option?
June 22, 2009 at 4:34 pm
So when you tried the ODBC connection, did you already have an ODBC data source configured to your Sybase DB? What happens if you try to connect to the...
June 22, 2009 at 4:29 pm
What are you wanting to do with the filename? Have you thought about using package variables to get it in there instead of trying to access the connection manager...
June 22, 2009 at 4:26 pm
It's just a difference in how the data providers read the data. If you're reading it from flat file, it does not know what the original format was from...
June 22, 2009 at 10:48 am
I don't know if they are really bugs. The Checksum function does not guarantee uniquness so you could end up with a row being identified that is not a...
June 19, 2009 at 12:47 pm
Paul White (6/19/2009)
John Rowan (6/19/2009)
I would question their use even when implemented correctly.
Heh. Well unless you are $deity posting under a psedonym, I think we're going to need more...
June 19, 2009 at 12:36 pm
Viewing 15 posts - 1,366 through 1,380 (of 3,232 total)