James, see my post on a similar forum:

http://qa.sqlservercentral.com/forums/shwmessage.aspx?forumid=148&messageid=349385

Let me know if that helps.

Steve

Hi,

You can't single-click on the ExecuteSql task and then drag the green line to the Data Flow task?

You could create a Script Task Component that sets the value of a package variable to true or false based on whether or the file is there.

Then, you can change...

All,

The standard security on an SSIS package is "EncryptSensistiveWithUserKey" which only allows the user that created it to be able to run in as long as there is sensitive information...

Hm, I'm not sure then.. I see what you're saying, but I don't really have a suggestion on how to get that value dynamically... Sorry I can't be of...

I'm not sure why it would stop working, but as a regular practice, I would put the column names on your insert statement,

TRUNCATE TABLE [dbo].[agingData]

INSERT INTO [dbo].[agingData] (col1, col2, col3)

...

You could set up an OnError Handler at the package level and set up an SMTP connection and send an email on the package failure. When you say "setup...

When you have a SQL Server database with a fill factor of 50%, it's my understanding that each page will leave 50% of free space to allow for clustered indexing...

Just tried re-creating the profile with the same results. The server I'm using requires SSL on port 465, do you think I need to open up a port so...

Thanks for the reply... I was just mentioning my Outlook settings in relation to the settings I set up in Database mail. The settings work in Outlook but...

You can have your app convert the format to mm/dd/yyyy and then convert the date pulled in by your query to that format..

CREATE PROCEDURE ap_getInfo

@importedDate datetime

AS

SELECT CONVERT (varchar, [dateColumn], 101)...

I had the same problem with my FTP Task.  The problem is that the package views the FTP password as "sensitive information" and the default setting is "EncryptSensitiveWithUserKey".  This setting...