Line breaks meaning carriage returns. I have an SSIS package that dumps out tables from a database into flat files and I have to verify the counts in the...

MSDB for SQL 2008.

A day and a half later, I have a slightly improved solution that is inspired by this site:

http://www.bidn.com/blogs/BradSchacht/ssis/1575/batch-files-command-lines

In my Execute Process task I have removed the value for...

http://www.sqlservercentral.com/Forums/Topic365090-148-3.aspx

http://codingstuffs.blogspot.com/2007/03/pgp-inside-ssis-package.html

There are plenty of examples of PGP encryption being called from an Execute Process task where the PGP server is on the same box as...

Something like:

create function dbo.Conditional_Lookup

(

@vID int

)

RETURNS varchar(255)

as

BEGIN

declare @vOutput varchar(255)

declare @v1 varchar(255)

declare @v2 varchar(255)

select...

Have you tried writing a SQL scalar function to accomplish it? That would be the way I'd begin.

Once in a while, SSIS loses my VB code too. I don't have an explanation other than the product is a little buggy.

One possible work-around is to perform all of the stored procedure calls from a single umbrella procedure; i.e.,

create procedure Call_them_all

as

exec sProc1;

exec sProc2;

...

This way you don't need...

Well, I have a solution that works. I gave up on the FTP task. Instead, I create a batch file on the FTP server. I have shared...

I'm trying to imagine any single chore harder in this world of IT then getting the SSIS FTP task to work when run as a job. Why does Microsoft...

Karen, Google is our friend. I just did a quick search and found these pages:

http://stackoverflow.com/questions/10078745/what-ssis-task-can-be-used-to-download-files-from-an-https-url

http://microsoft-ssis.blogspot.pt/2011/05/download-source-file-from-website-with.html

I discovered this page:

http://sqlserverdownanddirty.blogspot.com/2011/07/ssis-execute-process-task-hangs-when.html

I added the SEE_MASK_NOZONECHECKS environment variable to the server that houses the SQL installation where my package resides. It now works as a job!...

Well, that certainly is a complex spreadsheet. You could see if you can download the spreadsheet using a script task. (I don't know how it can be done,...

Karen,

You could try downloading the spreadsheet to a location that your SQL Server can see. Then run the import/export wizard on the file you downloaded.

Phil,

That is why I'm putting this command at the top of the batch file:

pushd "\\PGPServer\temp"

I'm trying to avoid that context issue. What seems to be happening is that...