Ten-second lesson: click once on the FTP task to select it and then hit F9 to set the breakpoint, which will appear as a red dot.

Execution should now pause...

Can you put a pre-execute breakpoint on the FTP task to check its properties at run-time?

At what point is this error appearing? Is it during package execution, or when the package is firing up and validating?

I use the version of BIDS that came with SQL 2008 R2 Dev Edition to build and edit SSIS packages that get deployed to SQL 2005 Standard Edition servers. Works...

Hmm, I'm no DBA:-) This might help:

SELECT * FROM fn_my_permissions('msdb.dbo.sp_ssis_getpackage', 'OBJECT')

where permission_name = 'EXECUTE'

If it returns a row, you should have EXECUTE permission. If not, you might have to GRANT...

srilu_bannu (11/1/2011)

---

Hi all,

we have one new server installed with two instances. One is test and other is prod.

Server\prod instance is working good when i run ssis package using SQL Agent,...

Or this may help.

declare @maxlength TINYINT = 10

declare @String Varchar(100) = 'abcdefghijklmnopqrstuvwxyz'

select @String, LEFT(@String, @maxlength)

Here's a two-pass solution.

Add a new column to your source data - HourlyRate.

Pass 1: Update HourlyRate to be the flow rate for the hour ending with the 'current' row, where...

Sure is. Declare a table variable to hold the results. Then

insert into @Table

exec sp_xxxxx

After that, you can select from your table...

I'm not familiar with Unix timestamps, but could you use a calendar/dates table (with appropriate 'XTimestamp' column) to help with this?

If all that you are trying to do is to populate a DateCreated column in your table, why not just create a new datetime column with a default of GetDate()...

The data conversion task should do the job - are you aware that it creates a new variable (so you need to change your column mappings to use what the...

This error

is too much of a coincidence. You must be writing to a pre-2007 version of Excel, which can support a maximum of...

Not natively.

If you can find a C#/VB solution, we can probably shoehorn it into SSIS somehow.

You do this not in the connection manager itself, but when you add a source in your dataflow. You will get the option to set 'Data Access Mode'. Set it...