Viewing 15 posts - 12,961 through 12,975 (of 13,849 total)
Just to clarify - you have a single (large) source file that is directed to one of 20-30 tables in multiple databases, depending on some attributes of the source data?...
March 4, 2009 at 5:08 pm
Check that the SQL Agent service has sufficient privileges to run this package - maybe a privileged domain account is needed and currently it is set to local system ...
March 4, 2009 at 9:45 am
OK, as you've probably discovered, there is no XML dataflow destination in SSIS, so your task is not simple.
But you're not the first to want to do this. Check http://blogs.conchango.com/jamiethomson/archive/2006/07/11/4209.aspx...
March 4, 2009 at 5:15 am
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
Viewing 15 posts - 12,961 through 12,975 (of 13,849 total)