You can also just use a derived column component. I often do that as I build a package and put a dataviewer on the pipeline so I can keep an...

Hi Renato,

My suggestions are more architectural than anything as I don't know how you can proceed with package execution in the parent based on selective errors in the child (If...

Hi,

Setting up a linked server is a way in which you can execute queries against distributed databases.

So if you have say an Oracle database that handles your call centre operational...

Hi,

You could set up your workbook as a linked server, or just use a distributed query

HTH

Unfortunately, if you don't have the option of saving dtsConfig files in test/qa/prod folders, you are going to find it hard to set up your SQL server configurations. An XML...

Hi,

I don't particularly like the deployment utility as it tries to do things that you don't necessarily expect.

I ended up writing a generic package which loops through a folder...

Don't forget there are a whole bunch of dynamic views and functions in SQL2K5 which can give you a lot of useful info.

sys.dm_exec_query_stats

sys.dm_exec_requests

sys.dm_db_index_usage_stats

sys.dm_db_index_physical_stats()

just to name a few... worth checking these...

In some circumstances using SQL can be the right way to go, but I reckon that in this example performing the logic in the dataflow will prove quicker.

What you're effectively...

Hi Kajal,

If you do a google search on "SSIS Pivot" you will find there are quite a number of articles dedicated to this subject.

Why don't you have a look through...

In which case, your lookup query was correct and you just need to adjust the expression downstream. (TRIM(CUST_AGRMNT_NUM) == "")||(ISNULL(CUST_AGRMT_NUM))? "Y":"N"

Hope this helps

Hi Riga,

I think my post wasn't clear enough and so I'll try to answer each point 1 by 1.

I decided to stage data into STAGE_DDA_REV_ADJ table

because I need to see...

Hi,

If you want to use a table function as a source in SSIS then you will need to use a SQL command from a variable.

Use an expression to derive the...

This is always a problem with Excel and there is no tidy way to do this.

If you don't have a way to descriminate between the records, you could add a...

In this example I'd say that your best bet is the...

I have to agree on both the points above which may leave you wandering why I said what I said. Apologies in advance for the long ramble...

I agree that...