Why dont you split it out?

What you could do is to query sheet 1 for all the data, and then have a column derivation for DefaultValue.

Therefore, each row passing through...

Is your header row on the 5th row?

I have one such a situation where my headers are all over the show (the horse has already bolted, there are thousands of...

Use a for each ADO enumerator.

Now you can write a query to get your connection strings, and pass this to an object variable.

Good luck

~PD

I agree that in most cases you can avoid the use of temp tables by structuring your query slightly differently, but for sure, sometimes they are unavoidable.

One such a case...

Whoa!

That does sound a tad bit strange...

I spent about 3 days understanding configurations in SSIS (actually I kinda figured that if I was going to add dynamics to my packages,...

Thanks Michael,

After giving some thought, I am going with the scripting task, as this is a once off kind of assignment where most probably the only person who cares...

The only reason I am "staging" data at the moment is because there is a very real audit requirement to have each and every control flow balanced.

It was really thought...

Brandie,

Apologies, I didnt realise there was a second page of postings when I read the thread.

Good luck with this one, I have no idea regarding any of the workings of...

Hey,

The FTP task should allow you to do this quite effectively.

a) Create a FTP connection in your connection manager. This is for your source FTP site

Specify...

Just call me slightly ignorant, but why would you consider usng temp tables in SSIS?

From what I understand (and each growing day it appears to be less) from temp tables,...

Hey Colin,

This normally happens when the size of your destination is set to for example 10, but the size of your source is set to 15.

Easiest solution is to ensure...

Hey,

Even if your windows user has access, this job will be run by your SQL server agent.

As such, the question will always be, does your SQL server agent have rights...

Hey Nat,

Not that I have ever tried to convert data from Oracle, but I do know that SSIS is very finicky about handling Nulls.

How about using an ISNULL equivalent in...

Brandie, create deployment utility is on your project (under the icon which looks like an AS database0

Right click on this and select the properties.

Look at deployment utility.

If this option is...

Hey,

My problem with the FTP task is that it is not very dynamic with the more intense stuff.

For example, I have to FTP files from server a to server b...