I have a odbc connection to a Cache' DBMS and I connect via ADO.NET in my SSIS package. Now, I have a query that is executed perfectly when I connect directly to my Cache' database however in SSIS it returns nothing. This is because in runtime the '-'
in my datetime is being converted to '/' by sql server. Any workaround to get the '-' to persist in my query?
View Complete Post