they are all varchar.

that means that it should be in ""!

That worked. Thank you!

Does anybody have any other solutions to this problem? i'm having this exact issue.

-I originally had an alias as the address, but have since changed it to my personal...

Thank you.

Is there a difference between doing it this way (importing them into the MSDB database directly) as opposed to the whole deployment utility thing?

http://www.nigelrivett.net/DTS/SSISConfigurationFile.html

I found this link very useful. It will show you how to make an XML configuration file.

Lowell, this might be possible. thanks for guiding me in the right direction. I will look into this

ragie

Well, i have two SSIS packages that are quite similar to each other which needed to be split for various reasons.

However, in each package I call a stored procedure....

THX again.

one more thing.......i want to learn sql really well. i know it will come with experience, but i wanna learn it quicker than that:)

do you suggest books, online course, tutorials....???...

incorrect syntax near ','.

when i take out the 'O', i don't have it, so....

ok.

CREATE TABLE [Files]

(

[fileid] [int] IDENTITY(1,1) NOT NULL,

[dir] [char](1) NOT NULL, --this is 'O'

...

sorry bout that Lynn.

i'm writing a sp where the goal is to get two output parameters: the fileid, and filepath. as you saw from the first post, i populate...

Thanx Lynn. i don't know why i didn't see that!

quick question, is it possible to do an INSERT SELECT like this:

INSERT INTO Files (Dir, filePath)

SELECT('O', filePath) FROM #Temp

it's a...