Here's my configuration :
Windows Server 2008 R2
SQL Server 2008 R2
I designed SSIS packages running well in BIDS.
In these packages I have ScriptComponent whith stringbuilder preparing update queries I execute later.
In these strings I manipulate, there's dates.
As my database as well as my source are in French I use :
Dim myCIntl As New CultureInfo("fr-FR", False)
Threading.Thread.CurrentThread.CurrentCulture = myCIntl
Else I get issues on date format.
Everything is ok when run under BIDS.
The SSIS packages are SQL Server stored and called from a SQL Server job.
Then I have error pointing to the ScriptComponent task where I do all my stringbuilder ...
I don't know why (of course as I'm asking for help ;-) )
Thanks a lot if you have any guess of why there's this different behavior.
View Complete Post