I tried that too, still no success.

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...

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...

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...

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...

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...

Thanks Mr.Pettis

Thats what I'm thinking. The developer originally notified me that their web app was unable to connect. Once I dropped...

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...

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...

Voted 😀

Great, hopefully it works. Waiting to hear back from him.

Thanks for your help.

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...

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...

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...