sql server dts: SSIS issue or OLEDB issue? -- sql server dts

SSIS issue or OLEDB issue?

TheMadTexan
7/7/2006 10:26:01 AM

sql server dts:

Anyone using SSIS to pull data from Oracle is well aware of the issues
associated with parameterized queries. I say issues, there really is only
one - you can't create a parameterized query....

Anyway, I'm wondering if this is an SSIS limitation, or if any product using
OLE DB as it's connectivity solution would have the same issue because it's
an OLE DB problem?

RE: SSIS issue or OLEDB issue?

Drutch
8/28/2006 12:51:02 PM

What is the usual work around for this? I suppose you could wirte a script to
create a huge where clause generated by values from a lookup source, but
that's not very elegant and is there a size limit issue? How have others been
solving this issue?

[quoted text, click to view]

RE: SSIS issue or OLEDB issue?

Phill
10/19/2006 1:58:02 PM

I define a package variable called mySQL and within a VB Script I set it to
the SQL I wanted.

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.