You don't need SSIS of bids to do this.

Also, your query above will not move the data from the source tables into new tables but rather from your source to...

If your tasks are not dependant on each other through precedence constraints, there is nothing stopping you from this it.

Do you want the other task to check on the first...

I suspect, the path is not found then...

Firstly, the value of the variable means nothing to the variable. It's a string. You can put what you like in it.

As for...

You have already setup logging so you are 90% there.

What options do you see in the Logging Details tab? You have looked in the logging details tab right?

A stab in...

You could use rownumbering and a conditional split. 0-10000, go here, 100001-200000 go there etc. Not very flexable though.

I would rather use a script component as a destination and manually...

That is not a connection manager problem.

If you have 40 data flows with 40 lookups with 40 queries, guess what? You have many many places to change this.

If you have...

If it is a once off, use BCP. The work required to build a package like that is not worth it.

If you really wanted to, You would have to create...

HA HA HA. I could not remember what .xls was for. Assume was a typo for xml. Now I feel rather stupid...:blush:

ok, try this. Delete the lookup (Bare with me here) and add a new one. Does it work?

If so, add a new column to the lookup query. When you click...

In your derived column component, you have two nodes in the left hand tree. One is variables, one is columns. Look for the System::Contrain.... one, drag and drop it into...

Using the derived column, grab the value from the System::ContainerStartTime As good a time as any.

I assume you are talking about xml file and not xsl?

Regardless, use a variable to hold the filename. Use expressions in the variable to dynamically change the value.

As for moving...

don't fiddle the advanced editor.

When you change your query, just add a 1 as xxx to it, it should break the mappings. CLicking back on the mappings shows the new...

Why not convert it at source? Doing it in the DF is a waste of time(CPU) and memory. Unless of course, you are going to use the string value.

I am...

Why are you selecting the whole table though?

If you are not going to use all the columns as either keys or returned values, do not select the whole table. It...