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

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 the package. However,...

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! 😛

Talk...

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