You're saying that the data is not all going in to REPLON1.dbo.crm_staging?

So, for example, you'll have a table like REPLON1.dbo.crm_staging_UK, and another one like REPLON1.dbo.crm_staging_FR, etc...?

If that's the case, would...

If I understood correctly, all your markets are contained within the same directory:

"\\viperlon1\_development\_live\import\"

Then, from there, there is a set of subdirectories.

Actually, I realise now that the script isn't quite right...

Why do you need to do that?

Are you trying to only get back the files which have that market code?

Or, are you trying to add that market code to the...

Like you mentioned, "Files" is a variable of type Object.

What is happening in the script is, I'm taking a given directory, and looping through all of the subdirectories in that...

You asked basically the same question in another thread.

Like I indicated in that thread, your best bet is to use the Lookup task.

You have only one file, which you want...

Yeah what you want to do is, in your solution explorer, right click, and choose to add existing package, then select the .dtsx file I included.

Don't think you can do that.

What you can do instead is use package variables, and have the package configuration reading from a table. Then, before executing the SSIS package, set...

If you want to use that approach, just change it from an Integration Services job to a normal SQL Server job -- Type should be Transact-SQL script. Choose the correct...

There's no advantage to using xp_cmdshell. Both approaches end up using it. The only reason why I like using the xp_cmdshell approach is because I don't really like the interface...

See attached .dtsx, should be able to handle what you're looking for. Just add it to a project and take a look at the code. You'll need to modify the...

Are you sure about that CozyRoc? I swear I've tested that before and found that it was the server which had the package on it which was doing the work....

The Lookup task basically loads the entire content of a procedure or a table into memory, and then performs lookups against that table for each row that you are passing...

What I'd recommend you do is have three data flow tasks.

In the first data flow task, you load Table1A. Use the Flat File Source as your input, and point it...

The machine which is running the .dtsx package is the one on which the package resides. So in your case, it will be running on Server 1. This means that...

You can ignore that error - it doesn't actually affect anything.

If you want to remove it completely, then what you'll want to do is change the encryption type of the...