Using Dtexec UI .

It seems we need to uncheck {Check for publisher revocation certificate} option in Internet options, so that it cuts off the time checking for it.

I recreated the ADO.NET connection and its working now !

Koen.,

It lookd like working.. But its not !

Thanks Koen!!! That works 😀

They have just used

Select ..... For XML PATH

[Execute SQL Task] Error: An error occurred while assigning a value to variable "VAR_Data": "The type of the value being assigned to variable "User::Data" differs from the current variable type....

Koen,

I am using Execut SQL Task only, but when using Single row result set it throws error.

could you pl. help me on how to get the SP result stored...

So how should I get the SP result in single row result set

Thanks

Even when i use FullResultSet the error is not captured.

May be I need to use "Single Row" result set.

But dont know how to get the Stored procedure result in Single...

I need it to use as input variable in XML Source in Dataflow later 🙁

Yes.. I have given XML resultset and storing in one variable.

When Access Denied on exec sp, the Variable has value :

<ROOT><?MSSQLError HResult=\"0x80040e09\" Source=\"Microsoft SQL Server Native Client 10.0\" Description=\"The EXECUTE...

E.g: Access Denied on Stored procedure

i used this code page 437 – OEM United States and it solved the Issue.

But when tried with 37 IBM EBCIDIC US/Canada and 500 IBM EBCIDIC International code page,...

Yes Koen.. I will use 1252 instead of Unicode.

just curious to know, if there is any specific code page related to mainframes..

Koen,

I managed to write an SSIS expression for this

Derived column 1 - Convert dbtimestamp to DT_WSTR (Add new column)

Derived column 2 - Expression (DT_STR, 4, 1252)DATEPART("yyyy", GETDATE()) +

RIGHT("0" +...