Viewing 15 posts - 11,056 through 11,070 (of 13,877 total)
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...
November 1, 2011 at 2:57 pm
Can you put a pre-execute breakpoint on the FTP task to check its properties at run-time?
November 1, 2011 at 2:41 pm
At what point is this error appearing? Is it during package execution, or when the package is firing up and validating?
November 1, 2011 at 2:40 pm
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...
November 1, 2011 at 2:30 pm
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...
November 1, 2011 at 1:37 pm
srilu_bannu (11/1/2011)
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,...
November 1, 2011 at 1:21 pm
Or this may help.
declare @maxlength TINYINT = 10
declare @String Varchar(100) = 'abcdefghijklmnopqrstuvwxyz'
select @String, LEFT(@String, @maxlength)
November 1, 2011 at 5:50 am
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...
November 1, 2011 at 3:29 am
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...
October 31, 2011 at 9:44 am
I'm not familiar with Unix timestamps, but could you use a calendar/dates table (with appropriate 'XTimestamp' column) to help with this?
October 31, 2011 at 9:12 am
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()...
October 29, 2011 at 12:34 am
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...
October 28, 2011 at 8:31 am
This error
component "Excel Destination" (16)" wrote 65535 rows.
is too much of a coincidence. You must be writing to a pre-2007 version of Excel, which can support a maximum of...
October 27, 2011 at 2:23 pm
Not natively.
If you can find a C#/VB solution, we can probably shoehorn it into SSIS somehow.
October 27, 2011 at 2:03 pm
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...
October 27, 2011 at 8:45 am
Viewing 15 posts - 11,056 through 11,070 (of 13,877 total)