If domains are not trusted you have no way of connecting to the other sql server with windows authentication. xyz does not trust any users from abc so on your...

not in ssis i believe. but if you have a trusted domain, so cross domain authentication should work.

so can you add the xyz\akash login onto the dev SQL server as read write access and run the connection under that domain account?

Are the two domains trusted?

Firstly can you not use an oledb source instead of an ado.net source in data flow. i say this as an oledb sql command will allow you to easily...

Easiest way would be select customerid to a object variable the iterate through the variable with a foreach loop container with your ado.net source sql being select customer id, sales,...

I had a this problem with oracle client and SQL Bids Debugger (wich runs VS 2010 32 bit version). i think it has something to do with the 32 bit...

You need to do this using data flow. can is see the query you are trying to use for the source query. Where are the parameters stored to pass to...

There should be no reason why the file system task wont move having the source and destination as variables. I use it for all file movements and with an expression...

Not sure i understand.

What is the existing sql command that works. If you could post.

and how might that command change to be dynamic. (most probably answered when existing...

The only way i think you could achieve this would be to redirect the lookup error output add a derived column with null value then process the row.

Similar to what...

Thanks for the reply. Sounds like i need to talk to our software provider. We were lead to believe we could run our two week Double run with legacy test...

I have implemented Jason solution and understood it after reading the article thank you Jason. I see luis has improved it which i will give it a try tomorrow and...

Am i right in thinking i can create two tally tables.

Tallyeven with IDENTITY(INT,0,2)

TallyOdd with IDENTITY(INT,1,2)

And cross join those results ?

Hi

Thanks for the quick reply. I am going through the splitter info at moment reading on tally tables.(interesting)

It does look like i have extra complication in that the splitter needs...