Viewing 4 posts - 1 through 4 (of 4 total)
You have to make network share accessible for user that runs SSIS package. If it's not domain account I believe workaround would be to set permissions for everyone.
September 5, 2008 at 4:23 am
If I'm not mistaken there is a limit on expression (4000 characters). So if your query is shorter you could build it dynamic using expression. Other solution is to use...
September 5, 2008 at 4:13 am
hestenerwin (9/3/2008)
'Dts.Variables("User::SELECT").Value = "SELECT Col1, Col2 FROM Schema1.Table 1 WHERE Col1 <> Random Value AND Col2 > " & Dts.Variables("User::Max_Modified_Date").Value.ToString()Can you see any problems with this code?
First, ' sign...
September 5, 2008 at 3:02 am
Jim Russell (9/2/2008)
September 4, 2008 at 3:06 am
Viewing 4 posts - 1 through 4 (of 4 total)