Viewing 15 posts - 9,541 through 9,555 (of 13,874 total)
alane 46264 (11/15/2013)
Replace(DT_STR,4,1252) DatePart("yy",getdate())
with
Right((DT_STR, 4, 1252)DatePart("yyyy", getdate()), 2)
This will return the last two (Right) digits of the year (ignoring the "20" century).
You just answered a five-year-old post - hope that...
November 18, 2013 at 5:11 am
Koen Verbeeck (11/18/2013)
Phil Parkin (11/18/2013)
Batch size.
I think the limit in SSIS is smaller.
I've had issues with very large SQL statements in Execute SQL Tasks, but they were less than 64K...
November 18, 2013 at 1:00 am
Have a look at this page. All sorts of useful info on limits there, including max. batch size.
November 17, 2013 at 11:08 pm
Nomvula (11/17/2013)
i've managed to find the error after going through my script task over and over again and found that i didn't assign the...
November 17, 2013 at 9:59 am
Have you tried putting a breakpoint in the script task and then stepping through it line by line to determine exactly which row is generating the error? Might help you...
November 17, 2013 at 8:38 am
I have a string variable which stores a big set of sql statements, ie insert statements. The insert statement intends to inserts about 200K rows with 10 columns (Lots !)
I...
November 17, 2013 at 2:30 am
Try using SELECT instead of PRINT.
November 15, 2013 at 11:40 pm
Nevyn (11/13/2013)
An article in doing this in SSIS with scripts:
http://www.blue-chip.com.au/ssis-file-with-header-detail-trailer.aspx
Basically reads the file as non delimited and parses it in a script...
November 15, 2013 at 2:26 am
Any ideas?
I would start by taking Excel out of the equation. Output the data to CSV (or fixed-width) and work from there.
November 15, 2013 at 12:03 am
SPtiruttani (11/14/2013)
I need the to subtract the value from the previous record and insert into another table
Declare @temp Table( [DeviceID] Int,[ctDate] DateTime,[Value] INT )
Insert Into @temp Values(1,'20131114 00:00:00',10)
Insert Into...
November 14, 2013 at 11:58 pm
Does your SQL Agent proxy credential have access to the file? Is it a domain account?
November 14, 2013 at 1:59 pm
Have a look here and see whether it helps.
November 14, 2013 at 1:04 pm
The proxy account also needs to be associated with the SSIS subsystem, I think.
November 14, 2013 at 12:29 pm
OK, maybe you could put some more sophisticated error-handling in the script in an effort to work out exactly which row is causing the error. I don't remember having any...
November 14, 2013 at 12:23 pm
Viewing 15 posts - 9,541 through 9,555 (of 13,874 total)