Viewing 15 posts - 12,931 through 12,945 (of 13,838 total)
After the data is in the intermediate table, can you just fire off seven INSERT commands?
INSERT INTO table1(,,,,,)
SELECT .... from intTable where ProdPrefix = '01'
INSERT INTO table2(,,,,,)
etc etc
Should be faster....
March 16, 2009 at 7:15 pm
peterk1961 (3/16/2009)
we do similar processing using stored proc but interested to see if there is a way to do this in SSIS.Thanks.
Peter Kennedy
Hi Peter
There are probably several ways of using...
March 16, 2009 at 6:57 pm
Add a Derived Column transformation to break up column two as you need.
The expression for column 1 will be something like this:
SUBSTRING([PersonName/FatherName/RationCardNo],1,FINDSTRING([PersonName/FatherName/RationCardNo],",",1) - 1)
That will extract all the text from...
March 16, 2009 at 9:24 am
As I suggested, you could create a new 'staging' table in your SQL Server database - just a table of text fields wide enough to accommodate your data - and...
March 16, 2009 at 8:48 am
Both SQL Server? Can you use linked servers?
March 16, 2009 at 8:44 am
Can you confirm that your Excel file contains only 2 columns? If so, that's an unusual format, but there should be a way ...
March 16, 2009 at 7:29 am
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
Viewing 15 posts - 12,931 through 12,945 (of 13,838 total)