Only tried it once with the end user and can't remember error message. It didn't seem to matter at the time cause I knew they didnt have a login...

I beleive Windows. Here is my connection string from the ADO code.

Provider=SQLOLEDB.1;" & _

"" & _

...

Awesome SSC Rookie... this works :w00t: Not sure if you can mark your reply as the answer or not, but it works

Thanks

need to run regsvr on following files (regsvr32 msxml3.dll" & regsvr32 msxml6.dll

I ran command line, browsed to C:\Windows\System then pasted in "regsvr32 msxml3.dll" and then "regsvr32 msxml6.dll" ...

I installed all updates. I tried downloading SP1 but there is no version for my operating system. Windows XP is not on list of supported operating systems. ...

declare @T1 table

(Customer int,

Job int)

INSERT INTO @T1 (Customer, Job) VALUES (1, 22)

INSERT INTO @T1 (Customer, Job) VALUES (2, 23)

INSERT INTO @T1 (Customer, Job) VALUES (3, 24)

INSERT INTO @T1 (Customer, Job)...

rebuilt package from scratch and it works. File must have been corrupt or something.

it ran once, then i tried again and it fails. I didn't change anything. I just tried to run it again. I thought it may be a...

i have a script task in the loop and pass a column as a variable into the loop. it is reading each variable correctly. if i disable the...

yes, i use the proper schema name. I took out the Crimes for the forum only.

I took out parameter and still can't get procedure to execute.

It works in the query builder pane of the SQL task, but not in package. I get error says...