Viewing 15 posts - 10,876 through 10,890 (of 13,872 total)
Can you post the text of the error you are receiving?
February 14, 2012 at 9:34 am
Try using the inserted table.
I do not think that Ian was taking the **** with his 'strange requirements' comment, just helpful.
February 14, 2012 at 7:20 am
ram_kamboz2k7 (2/14/2012)
Well I have changed it around and seems to come up with the same errors.
The users table...
February 14, 2012 at 3:28 am
ram_kamboz2k7 (2/14/2012)
set @path = 'C:\'
EXEC master.dbo.xp_create_subdir @Path
I have created a directory first and foremost.
EXEC xp_cmdshell 'bcp "SELECT * FROM USERS" queryout "C:\gradfive.txt" -T -c -t,'
I want the...
February 14, 2012 at 3:04 am
SQL_Surfer (2/13/2012)
February 13, 2012 at 3:17 pm
Don't know (been years since I last used DTS and I've forgotten how it works!)
February 13, 2012 at 3:08 pm
SQL_Surfer (2/13/2012)
Stored proc on remote server references a linked server to the calling server (where the package...
February 13, 2012 at 2:53 pm
The ExecuteSQL task requires a connection. Where is that connection pointing?
Can you also post the full text of the error message which you are getting?
February 13, 2012 at 2:02 pm
So, in SSIS, you are using an ExecuteSQL task to initiate a stored proc on a different server, is that correct?
Have you configured a connection to the other server?
If not,...
February 13, 2012 at 1:42 pm
vinodoss57 (2/13/2012)
this is vinoth. i have faced the same issue you have mentioned.I ran the query INSERT INTO OPENROWSET ('Microsoft.Jet.OLEDB.4.0', 'Excel 8.0;Database=c:\resource_add.xls;','SELECT...
February 13, 2012 at 5:35 am
You create the named ranges in Excel, not in SSIS - they are part of the spreadsheet.
February 10, 2012 at 3:10 am
padmanabhuni.k (2/10/2012)
If you don't mind can you explain little bit clearly.
It was pretty clear, to be honest.
Which bit don't you understand?
February 10, 2012 at 2:46 am
The OR is the problem, I think. Try
Department == "HR" || Department == "IT" || Department == "IG"
February 8, 2012 at 8:03 am
Viewing 15 posts - 10,876 through 10,890 (of 13,872 total)