Hi,

As a test I copied the info from the site word for word and pasted it into my script ocmponent:

Dim column As IDTSInputColumn90

...

Great thanks!

I think this is what I need. Question though; have you ever found a way to step through the code (F10 key) in script component like you can...

Yes, you can create a "Master" package. Inside your master package you can can run packages A, B, C, etc. and have each run based on whether the...

Hi all,

Figured it out. IIS was installed but server 2008 is very picky about which options need to be checked marked. Once I checked marked these options, I...

Ok, I'll try rebooting the server and let you know.

Thanks,

Strick

Yeah and nothing

Hi all thanks for your response. Unfortunately I can't insert '' into DB since null and '' are not the same thing. Destination would need to be null...

Yeah, I tend to agree with that too. I always put the schema in front of my tables. Why be lazy? Know what I mean? I inherited...

Great!

Thanks guys

Ooop I might have phrased my question wrong... THe double dots are occuring in the FROM section of a SQL statement I'm worknig with. So they actually have DB...

Great thanks!

That's just it. Conditional split will do the same thing. It will move a row to one flow or the other based on the condition. I need...

There are a few ways you can do this. You can either:

1) Use a Script component as a source and eliminate the first 2 rows and read the rest...

This should get you started. Use a script task. there's alot of different ways to do this but here's the method I used. You'll probably have to...

Sweet, thanks!! That's exactly what it was! I'll have to use a data conversion task to convert some of the columns to from string to numeric since they...