Thanks all,

that's going to take me some time to analyse. The source data is just terrible. They have been swapping the format of the dates on almost a daily basis....

Many thanks,

no permission to run sp_who. Please don't ask why or I may start to rant about having my hands tied behind my back. The table used by the OLEDB...

Without going into details. I am very constrained. Project deployment is not possible. They don't own the infrastructure and the DBAs insists that we cant use project deployment for some...

I have some 30 packages in my project. They break down into 3 styles of package

20 backup packages

5 that upload data

5 that download data

I should have been more assertive and...

Used a message box to show the variables. Will later update to place in a file. Is there a way to create the variables you need in a package rather than...

Thanks peeps.

will have to look at Powershell. Will pick up the script task code as that seems to suit me better

Many Thanks

Mark

I am constantly surprised that people build ETL solutions without picking up this book. I purchased it on Kindle, could have been my first Kindle purchase and was given the...

As an update. No longer think its the script template. My reason is I can open a VB Script task and same thing happens so both templates would need to...

Thanks Lowell.
I will have a look at that. Its less intrusive than uninstalling and reinstalling.

Cheers
M

This is not a solution but a suggestion. If that failed on SQL server would you be able to find out in SQL in which case use the fact you...

The more I look the more I see dead ends with this issue. 

I wonder if there has been an update or even going to 2015 Pro started this

Yep,
been through a couple of those. The first one seemed closest to my issue added the ComVisble(false) but that seems top be a red herring.

Everyone else is...

Ok
so with the next data flow task your data source will be an OLE DB data source querying like ..
SELECT
        EmpID,
        [dbo].[fn_capitalize](Name) AS Name,
       ...

Error Messages from when executed from SQL Agent job in Run 32 bit mode set in True and False modes
64 Bit error messages
======
SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. ...