Mickle (9/30/2010)

---

Hi, I was wondering if anyone out there has had any experience and success setting up the sql DTS backward compatiblity components using widows 7. I had this...

Sounds like you need to concatenate with single quotes, something like this or however it applies to what you are doing.

("select ? from ? where ??=" & " ' " & ? & "...

You have an extra quote before and after ''2006-10-16 00:00:00:000'' , check your format before you pass it to the proc......

Do a save as and save it to SQL server.