Viewing 15 posts - 12,991 through 13,005 (of 13,876 total)
I suggest you create a brand new table in SQL Server just to hold records that are imported (a 'staging' table).
Then amend your SSIS process to be something like the...
March 4, 2009 at 4:45 am
So is your question: "Can I use SSIS to convert a CSV file to XML format?"
March 3, 2009 at 7:13 pm
Now that I think of it, I have had this situation in the past too - I had a very elegant (or so I thought) control flow and I discovered...
February 23, 2009 at 5:46 pm
Strange. And if you remove the constraint it works ok? Are you sure that the problem is linked to the constraint?
Phil
February 23, 2009 at 1:04 am
You are trying to do database-type stuff without a DBMS :crazy:
You could do the whole thing row by (painfully slow) row in a script task. But when you have a...
February 21, 2009 at 11:59 pm
Bring the text file data into SQL Server, write a query to do the comparison, then output the results of the query as a text file.
Phil
February 21, 2009 at 10:04 pm
If you're doing this regularly and all of the data comes from source db, why not just remove the constraints on the target db?
Or ensure that you truncate in the...
February 19, 2009 at 2:30 am
kbatta (2/18/2009)
---I don't know if you can do something like that with delimited files.
---
You certainly can - and more easily than with Excel, I think.
Phil
February 18, 2009 at 10:05 pm
40 connection managers - I do not envy that at all :doze:
But the alternative is to script it all and that is not nice either!
There are so many different files...
February 18, 2009 at 9:39 pm
There is an Import/Export Wizard which uses SSIS, instead of DTS.
Just right-click your db in SSMS and select Tasks / Import (or Export) data.
That should get you started.
Phil
February 18, 2009 at 6:33 pm
If you create variables to hold the source filename and destination filename, this becomes a piece of cake, as all you have to do is set the 'IsSourcePathVariable' and 'IsDestinationPathVariable'...
February 12, 2009 at 5:57 pm
An alternative approach would be for you to add a 'Rename File' task at the front of your package to rename the Access db to be the simple, static name...
February 10, 2009 at 6:30 pm
If (for testing purposes only) you use a simpler package which has an explicit name for the Access db, does it work? I would guess not, but it would be...
February 9, 2009 at 6:06 pm
stricknyn (2/7/2009)
I think you are referring to the script task not script component. The script task (control flow item) lets you debug. The script component (data flow item)...
February 7, 2009 at 2:01 pm
Could it be that the columns are being interpreted as numeric (because the first few rows of data contain numbers in those columns)? If so, when the non-numeric data is...
February 6, 2009 at 7:44 pm
Viewing 15 posts - 12,991 through 13,005 (of 13,876 total)