Viewing 15 posts - 12,976 through 12,990 (of 13,877 total)
Why use SSIS for this? Sounds like a (relatively) straightforward stored proc.
March 16, 2009 at 7:23 am
Yuk, that is a horrendous requirement. Is there any way that you can tidy up the source data, rather than having to code around it - I am almost certain...
March 16, 2009 at 7:21 am
Why does the column order matter here?
March 9, 2009 at 12:40 pm
Can't you just grant the necessary folder permissions to the SQL Agent user and use a UNC path to access the files?
Phil
March 9, 2009 at 8:37 am
Further to Jack's post, the UNION also forces a sort - so you can remove your sort transformation completely and change your query to:
select lastname, fisrstname, titile, cellphoneno , ...
March 6, 2009 at 6:10 pm
The fact that you need only column 1 makes this a lot easier, I think.
Just import the whole record into a single column on SQL Server and then run an...
March 6, 2009 at 7:16 am
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
Viewing 15 posts - 12,976 through 12,990 (of 13,877 total)