Viewing 15 posts - 1 through 15 (of 15 total)
August 30, 2017 at 7:58 am
August 29, 2017 at 7:46 am
Hi Phil,
Can you get the required data using [msdb].[dbo].[sysssispackages] .
Please help to get the required o/p
SELECT
Name,
CAST(CAST(CAST([packagedata] as varbinary(max)) as varchar(max)) as XML)...
August 24, 2017 at 6:39 am
July 5, 2017 at 7:09 am
Thanks for the response. Working in SSIS hitting performance. So is there any alternative to directly convert .txt to .xlsx
July 5, 2017 at 6:17 am
July 4, 2017 at 2:23 am
June 30, 2017 at 7:50 am
Provided solution working fine . Thanks a lot for your help.
June 20, 2017 at 2:34 am
Data is coming from flat file so I can't use Sql functions.Please suggest on Derived expression or Script task
June 19, 2017 at 1:28 pm
June 5, 2017 at 7:33 am
May 31, 2017 at 9:12 am
May 31, 2017 at 8:25 am
Viewing 15 posts - 1 through 15 (of 15 total)