Viewing 15 posts - 31 through 45 (of 189 total)
Hello Uripedes,
Thanks for your response.
I went a totally different route and used jscript to grab the latest file. I use a EXECUTE SQL task to run XP_CMDSHELL and have it...
March 18, 2010 at 1:13 pm
Okay another question! hehe!
Basically I have the SFTP profile setup on our server from where we are going to run the SSIS package and get the file from the SFTP...
March 17, 2010 at 2:26 pm
Thanks guys for the responses. I just talked to the vendor and for this particular feed, they are only able to provide an XML file.
The only reason I was...
March 17, 2010 at 8:36 am
Okay, so i'll look into the EXECUTE TASK process. Thanks again.
Typically, is it preferred to receive data in XML format or flat file? I know this might be something that...
March 17, 2010 at 7:42 am
Hmm great.
So i've been reading SSIS does not support official SFTP file retrieval and that I have to use EXECUTE PROCESS task in SSIS to run a command line...
March 16, 2010 at 12:48 pm
Bhuvnesh (3/15/2010)
How ? is somebody resetting it without intimating you ?
Thats what I'm thinking. The developer originally notified me that their web app was unable to connect. Once I dropped...
March 15, 2010 at 9:33 am
This is a SQL account.
The web app connects to this database using the SQL login. I am thinking the idiot developers have the password specified incorrectly on the app side...
March 15, 2010 at 9:30 am
Thanks. Found out that it was state 8 which is a password mis-match.
Im confused as I only dropped and re-added the login at the database level and not at the...
March 15, 2010 at 8:42 am
Great, hopefully it works. Waiting to hear back from him.
Thanks for your help.
December 18, 2009 at 1:28 pm
I haven't watched him but he sent me his T-SQL which he was trying to run. I told him to use the "USE Database" statement. However, he was doing it...
December 18, 2009 at 1:24 pm
Okay so I'll expand on this.
Basically, I have a user who is part of a active directory security group called DataWarehouseTeam which has 5 other people. The DataWarehouseTeam login has...
December 18, 2009 at 1:15 pm
Thanks Cirque.
However, I did it a little differently.
I altered the authorization querying the DB where the user existed by typing in the below T-SQL:
USE [Database]
GO
ALTER AUTHORIZATION ON SCHEMA::db_ddlAdmin to dbo
GO
ALTER...
December 18, 2009 at 10:32 am
Viewing 15 posts - 31 through 45 (of 189 total)