Viewing 15 posts - 16 through 30 (of 162 total)
It didn't worked. I have an excel template where i copy the format from source to destination, once data loaded into the destination file, i am renaming it with file...
November 26, 2019 at 5:02 pm
i have a string variable where it holds the datetime stamp value. using the same in move too.
in between rename and move file system task. i have created dummy script...
November 25, 2019 at 9:40 pm
May i know the reason why i get this error The data types varchar and datetime2 are incompatible in the add operator. when i changed variable from date time to...
November 25, 2019 at 7:38 pm
SET @CaptureError= @CaptureError + ' ,Date: ' + convert(varchar(10), @Date,101)
Is this correct?
November 25, 2019 at 7:29 pm
Its kind of dump ; yeah . how can we merge it?
November 21, 2019 at 6:26 pm
its requirement.
November 21, 2019 at 6:13 pm
any one has sample script task to do this?
November 19, 2019 at 6:57 pm
so i need to select row delimeter as vertical bar {|} ?
November 19, 2019 at 6:14 pm
My Row Delimeter is {CR}{LF}
Format - Delimited
Text Qualifier as None
Header RowDelimeter - {CR}{LF}
Header rows to skip 0
columns names in the first data row box is unchecked.
November 19, 2019 at 5:38 pm
problem is each select statement is coming from different tables. first select statement is form student table, second one is form studentbook and 3rd is from studentarchive.
all tables has different...
November 6, 2019 at 10:16 pm
Because of this my main table is locking; i have to rollback explicitly if it fails.
for this SET XACT_ABORT ON; will work?
October 16, 2019 at 12:30 am
thank you, it worked
September 27, 2019 at 7:33 pm
How to rewrite as single statement with out variable?
September 27, 2019 at 7:15 pm
I tried this way
@[User::IsActive] == "0" ? "@[User::Path]+ "\\" + "Test_"+(DT_WSTR,4)YEAR(GETDATE()) + RIGHT("0" + (DT_WSTR,2)MONTH(GETDATE()), 2) + RIGHT("0" + (DT_WSTR,2)DAY( GETDATE()), 2)+ RIGHT("0" + (DT_WSTR,2)DATEPART("hh", GETDATE()), 2)+".txt"" ? "@[User::Path]+ "\\"...
September 24, 2019 at 8:12 pm
Hello David, Instead of calling from procedure, can we handle in SSIS package using script component? with out casting original columns from the table?
June 21, 2019 at 3:07 am
Viewing 15 posts - 16 through 30 (of 162 total)