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

Try removing line 255 of the data file and see whether anything changes.

Note: the post previous to yours is nearly two years old.

GilaMonster (10/25/2011)

---

I'll...

Gail, would you consider writing an article about this? It would generate lots of interest, I am sure.

I don't think so. There are custom components available here[/url], including more than one Regex component which looks promising, though I've never used any of them. Rather than doing that,...