Viewing 15 posts - 1 through 15 (of 100 total)
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...
August 20, 2015 at 9:49 am
not in ssis i believe. but if you have a trusted domain, so cross domain authentication should work.
August 20, 2015 at 9:18 am
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?
August 20, 2015 at 8:53 am
Are the two domains trusted?
August 20, 2015 at 8:21 am
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...
August 20, 2015 at 3:38 am
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,...
August 19, 2015 at 2:42 am
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...
August 18, 2015 at 11:21 am
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...
August 18, 2015 at 10:54 am
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...
August 18, 2015 at 10:43 am
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...
August 18, 2015 at 9:49 am
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...
August 18, 2015 at 9:10 am
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...
August 18, 2015 at 8:29 am
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...
May 21, 2015 at 12:01 pm
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 ?
May 21, 2015 at 11:24 am
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...
May 21, 2015 at 11:03 am