Is the destination columns in the SQL table going to remain fixed/constant?

Yeah I absoulutely agree with that. That was more or less why I chose the option to create the file. My plan was to have mutiple catch blocks...

Hi,

I'm doing this to ensure that the value entered in the package by users is a valid filename. Creating the file in the try catch block will catch the...

Hi,

Lookups are meant for looking up and returning data from a database table. Validation is up to the package creator since he/she would know what data needs to be...

Hello,

Thanks, i actually have a VB 2005 class I wrote some time ago to send emails. I can probably use that in my package. Was just curious if...

You're welcome, glad I could help!

Strick

Hello,

Are you putting a " in the text qualifier box? This would force quotes around all the output fields which would eliminate the commas in that field from being...

Hello,

I think you are referring to the script task not script component. The script task (control flow item) lets you debug. The script component (data flow item) does...

Hell yeah!

I was looking in expressions (4th one down) in the Fooreach Loop Editorwhich wasn't correct instead of Expressions in the collections section.

Thanks!

Strick

Interesting,

Unfortunately I can't invest in any third party products. I'll try the raw file source/destination part and see how that works out.

On a side note, do you know if...

Hi all thanks for your response. Just to add, when I mentioned the screen went out, its the graphics card. So using a projector or monitor won't work...

Hi,

Great, glad I was of some help. That's the beauty the about SSIS. It really lets you think outside the box. I'm a programmer by trade so...

Hi,

I usually use this as my rule of thumb... If the data needs to be grouped/aggregated only one time i'll do all the work in a stored procedure. But...

Do you know the PK at run time? Meaning are you using the PK from the Access database? Or are you inserting it into SQL and the PK...

Hi, yes I am only using the listed tables. I'm trying to figure out how to do update with a Execute SQL Task based on how I have my...