hello,
I'm using SQL Server 2005 - SSIS module to extract data from a progress database. It works fine except when I want to use a variable in my request like
select * from pub.vkorder_intake where datum_creatie=
@[User::StartDate]. I got an error message 10713 saying there is a syntax error in sql statement. I've tried everything without success. It works fine without variable.
Can anyone help? Thanks in advance
I'm using SQL Server 2005 - SSIS module to extract data from a progress database. It works fine except when I want to use a variable in my request like
select * from pub.vkorder_intake where datum_creatie=
@[User::StartDate]. I got an error message 10713 saying there is a syntax error in sql statement. I've tried everything without success. It works fine without variable.
Can anyone help? Thanks in advance