You haven't really answered the question - please look at it again. There is an article here which may give you some useful information about query analysis.

Or you could execute the SQL Agent job from a batch file instead - something like:

osql -E -Q "msdb.dbo.sp_start_job N'MyJob'"

It seems that Powershell can do it too. See here.

I suggest that you start editing your query manually & testing the results in Management Studio. Query builders can get you only so far.

Not that archaic ... so does C#.NET 🙂

OK, simpler version:

public void Main()

{

...

If possible, I would approach this slightly differently.

1) Set up your trigger to write data to a 'pending' table every time there is an update.

2) Create an SSIS task to...

Not quite.

You know that for some c.chg_ref_num, the filtering works as expected and for others it does not.

The suggestion is to find one that works and one that does not...

Please do this, as suggested already by Ninja's_RGR'us:

What I mean is find a row that is not correctly filtered. Get the input param from that row and run the function...

That is not T-SQL.

That's it? You expect others to take the time to craft a technical response to a question when you are not even prepared...

Perhaps you would be courteous enough to answer Lynn's question?

Jeff

FINDSTRING is a built-in SSIS function, see here.

Description

D-1,D2

D-2,D-U,T1

U-5,T2,K-5,T3

NULL

Is that real sample data? Or have you tidied it up to remove trailing commas, perhaps?

If it is real, you are going to get errors with your derived columns in...

KrishnaChaitanya (3/16/2011)

I have created a package which loops through a folder containing Excel inputs and loads in to the SQL server database. I have deployed the package in SQL server...