No this is actually the error message that I tried to simulate on my personal computer. However in my office I had bigint being returned from sql and int64 in...

Hi

You can use event handlers and then in whatever event you want you can use script task to pass datetime.now value to a user variable

Thanks

Sample data is like we have hierarchy like jobs--blocks---dcv---items---clearing times

Jobs block are fixed tags with fixed number of elements. Howere items are coming from a table. Under items...

It turned out that xmlns does not have any impact on the processing of xml files. Xml files are being used by some other application and it didnt has any...

Thanks ss i have converted it to project deployment model. a wizard came up , i selected the server name in (select source step). however i am stuck with the...

I have created SSISDB in SSMS and then opening BIDS . Right clicking on the project (not on package) and there I cant get an option for deploy (i am...

Very clearly laid out. Thanks. My query is that I have sql server 2012 edition with sql server data tools (2010 edition). I have managed to make a ssis catalogue...

Very nice stored proc. However would like you to explain it in at various places

such as

what is the use of sys.index_columns

I mean thorough explanation would also be very helpful.

Thanks

Lokesh

email...