Is there a reason you can't use multiple OLE db destinations? That would likely be the best way ... get the data from your source, do a conditional split...

Does this have to be done at the query level? This is basically a formatting requirement and something you would usually do at the client side.

There are ways to...

Nothing to do with the row_number() I don't think. But I am curious why you are using row_number() in a derived table, and then never using that number.

You are...

Tried to duplicate but I could not. It lets me mix parameters and hardcodes fine (both with and without BypassPrepare).

Are you sure the variable holds the value you...

I suspect this might be the issue.

From here:

Using Parameters with OLE DB Connection Managers

When the Execute SQL task uses the OLE DB connection manager, the BypassPrepare property of the task...

The best way I have seen this applied was at a call centre (had to right the scripts for it).

It worked better because it was a giant sample size of...

Jeff Moden (12/1/2013)

---

I don't use SSIS but, speaking from an old dude's perspective, I'd likely make the loading of each table a separate package for reusability and then have a...

What makes sense for you depends widely on the nature of your business and the scarcity of...

Can't you use an expression for the connection string property?

What version of BiDS/SSDT are you using?

Pre-2012, I believe all deployment was at the package level, and the accepted 'best practice' was to use DontSaveSensitive with configurations.

I am using 2012...

To DBAs, this isn't important, because *we* know that identity columns are arbitrarily assigned. However, the users of the report in question are accustomed to seeing mostly consecutive values in...

Isn't this true of television manufacturers, carpet makers, stereo manufacturers, and... just about every other business?

Would you be happy with a new stereo that could only play sound from one...

You don't need powershell if you don't want it.

An article in doing this in SSIS with scripts:

http://www.blue-chip.com.au/ssis-file-with-header-detail-trailer.aspx

Basically reads the file as non delimited and parses it in a script task.

Try this:

SELECT t1.ID,t1.SIMNO,COALESCE(t2.IMEI,t1.IMEI) AS IMEI

FROM #temp t1

LEFT OUTER JOIN #temp t2

ON t1.SIMNO = t2.Id

NOTE: There is one problem with the above. If the IMEI in the row with the ID...

The default would be strange either way. ...