Viewing 15 posts - 12,946 through 12,960 (of 13,841 total)
Could it be a permissions issue with the SQL Agent service user?
March 6, 2009 at 4:33 am
These look like variable-length records with variable numbers of spaces between the fields ... a bit of a nightmare.
Is it true to say that if two or more consecutive spaces...
March 6, 2009 at 4:28 am
No probs - it's an interesting thread.
To get the maximum response, I suggest that you create a new thread in the T-SQL forum specifically with this requirement, eg
Given the following...
March 6, 2009 at 4:06 am
🙂 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
Viewing 15 posts - 12,946 through 12,960 (of 13,841 total)