Viewing 15 posts - 12,946 through 12,960 (of 13,838 total)
🙂 I never said that it was going to be easy.
But there are some damn clever people in this forum and I'll bet that more than one of them could...
March 5, 2009 at 8:42 pm
If your SQL is really nifty, you may be able to code this up front in your SELECT statement by having a column at the end of every record which...
March 5, 2009 at 7:43 pm
Sounds like a permissions issue. Check that the SQL Agent service user has rights to access and delete the files.
Phil
March 5, 2009 at 7:28 pm
Just to clarify:
For each Excel file, you want to
a) Populate one line of an ImportLog table (LogID, Filename, LoadDate)
b) Populate a physical table with the Excel source data, plus...
March 4, 2009 at 5:36 pm
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
Viewing 15 posts - 12,946 through 12,960 (of 13,838 total)