DB is on Simple recovery. I have over 91 million records. Deleting in small chunks will take long time. This is not the only time that I need to delete....

This is test database with limited diskspace. I do not want the logs to grow. Is that possible?

Thanks.

Someone had deleted the data from test DB1, so I was seeing no data in variable. But as soon as I populated data in the table, it shows up in...

That is correct that the optimizer will not use the index.

Koen,

I ended up fixing the issue as follows:

WHERE

CONVERT(VARCHAR,s.ModifiedDate) > ' + ? + '

That actually worked. Thanks for pointing me in the...

Forgot to mention that I also got the error: "The Declare cursor SQL construct or statement is not supported."

Thanks.

I added the declare statement and replaces the ? with @Date. When I parse the query, it gives me syntax error. If I just use ? instead of @Date, I...

DT_DBTimeStamp is not avialable for Parameter Mapping.

THanks.

I am trying to fetch a subset of data from one database, insert that data into staging table. Then take the new records from staging and insert into the destination...

Hello Andy,

Thanks for your response. There must be a way to use the variable inside a query instead of storing it in a table.

Thanks.

Thanks for the link. I looked further in the output window and I only saw generic message that I posted earlier. I will post this issue now on the integration...

Thank you very much, I appreciate it.

I have a situation where if a job takes longer than expected, then the scheduler should be able to detect that and the subsequent jobs should start only after the...

I am trying to store the number in a char field. Wayne has the correct answer. Thanks Wayne, that works.

Steve,

Thank you for your help. I will output the results to csv file and try and let you know the results.

Thanks.