Guys,

More suggestions will be highly appreciated!!!!!

Thanks

Devesh

substring ("Archive_Full_20120731200002",1, (FINDSTRING( "Archive_Full_20120731200002","Full_", 1)-2))

Then how come the above expression is working where the exact string is used instead of a variable and still negative value is accepted!!! Does it...

Below is the expression to be evaluated:

Substring (@Variable,1, (FINDSTRING( @Variable,"Full_", 1)-2))

@Variable is the variable containing the exact string 'Archive_Full_20120731200003'

But when i used this as a expression, it gives the error...

Hi,

If the size of databases are very large and you are using backup compression technique then you should not include the Verify Backup option in the Backup job as the...

I even tried using a flat file instead of a Table in data flow destination but the dataflow task is somehow not working inside ForEach loop Container?

The values are coming...

I am using a SQL command in Source Editor: Where clause is using a parameter which accepts the value from ForEach loop after being transfered from SQL script Task

Select from...

I am really sorry for the confusion!

Currently my issue is with the second step of the package i.e DataFlow Task inside ForEach Loop container. Rest of the story for email...

I am trying to fetch the rows from the source table which have a timestamp(Column) within the last 20 minutes and then formatting the rows to send the data through...

The connection has been created through Connection Manager.

I tried DataFlow task outside ForEach loop container and it is working perfectly fin but failing inside ForEach loop container.

Hi Gail,

Is there any Upgrade certification with whcih I can upgrade my 70-431 MCTS(2005) to SQL Server 2008 or do I have to start all over again on 2008 version...

I am still expecting a reply from anyone !!!!!

I think the problem seems to be a complex one 😛

Guys, I am expecting a reply 🙂