Viewing 15 posts - 12,961 through 12,975 (of 13,874 total)
You could have a package variable - ProcName, for example - which is set as a parameter by the stored proc as part of an Execute SQL task. Or you...
March 17, 2009 at 7:14 am
What's the error message?
March 17, 2009 at 6:55 am
SK (3/16/2009)
---filename_20090316_1015PM.csv might help out in the long run in knowing when the file ran (instead of looking at the modified date and properties of the file).
If I ever...
March 16, 2009 at 9:45 pm
So a sequence number of 8 means the record was INSERTED once and updated seven times (1 + 7 = 8)?
March 16, 2009 at 9:40 pm
Is the sequence number arbitrary? If so, why not make it an IDENTITY(1,1) field in the destination table and then SQL Server will take care of the numbering for you.
March 16, 2009 at 7:32 pm
pleasehelpme (3/16/2009)
Technology:... Any better plan?
Backup/Restore? What exactly do you mean by "full load"?
March 16, 2009 at 7:18 pm
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
Viewing 15 posts - 12,961 through 12,975 (of 13,874 total)