May 1, 2012 at 1:21 am
Dear all,
I have a 2 DTS Package. One package read csv file and insert all values from file to temporary table that all field has varchar column type. After all flow successfully execute, i call another DTS Package.
In my second DTS Package i transfer data from temporary table to my main table. I put data conversion flow between temp table and main table to convert data from temp table so it can fit data type in main table.
In my temp table i have data contain date like '12 04 2012'. When i run my DTS package that transfer data from temp table to main table from SQL Server (i deploy dts to sql server), it return '2012-04-10' for Date column in my main table.
The question is, when i call DTS package from my ASP.Net application, for date like '12 04 2012', it returns '2012-10-04' in my main table.
I have change regional setting in my development environment, nothing change. I have change .Net Globalization in IIS 7, nothing change too.
Maybe anyone here, has a solution for my problem, i would be very appreciate.
May 1, 2012 at 2:23 am
Are you passing any parameters from the .NET application to the DTS package?
If not then I suspect the issue is at the SQL Server.
If you are passing a parameter from the .NET application, you may want to insert a break statement on the line that calls the DTS package and use the bugging tools in .NET to see the values of the parameters being passed to the SQL Server.
:exclamation: "Be brave. Take risks. Nothing can substitute experience." :exclamation:
May 1, 2012 at 2:51 am
Robin Sasson (5/1/2012)
Are you passing any parameters from the .NET application to the DTS package?If not then I suspect the issue is at the SQL Server.
If you are passing a parameter from the .NET application, you may want to insert a break statement on the line that calls the DTS package and use the bugging tools in .NET to see the values of the parameters being passed to the SQL Server.
Thanks for your answer..
Nope, i'm not passing any parameter to DTS Package, i'm just call it via standard LoadFromSqlServer method in my application.
If it's my SqlServer that has problem, do you know what's the problem?
i have simulate this problem in 2 development environment,and i still have same result in both environment.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply