Attached are the SSMA for Sybase to 2005 from Roger's first link and the two white papers from Roger's second link.

The expression builder SSIS offers are just abstractions of .NET code. SSIS expressions were not meant to handle everything...but they do handle most inline data manipulation needs. The Script Task...

My Flat File Connection is setup with a double-quote as a text qualifier and I did not have any issues importing a file containing the data shown...

I see this issue...

I am not having the same issue. Do you have a Text Qualifier set on your Flat File Connection?

Please post the line of the file having the issue, the properties...

I was giving some time for the experts to chime in since I do not have a definitive answer for you...but since you reposted I'll jump in...

Your WHERE clause tolerates...

Martin Stephenson (3/14/2011)

---

Do i ask for multiple LUNs pretending that there is a C:\ (OS), E:\ (temp), F:\ (Data) and G:\ (log) disk structure or do I just present a...

I am a bit confused as to what you're now asking. My solution was based on using OPENXML...it lokos like somewhere along the line though you switched to using CROSS...

You can achieve this by using the Derived Column Component to add a blank column to your data set and then using a "Transformation Script Component" to populate the...

USE msdb

GO

DECLARE @proc_name SYSNAME = 'stored_procedure_name' ;

SELECT *

FROM dbo.sysjobsteps

WHERE command LIKE '%' + @proc_name + '%' ;

This should get you there:

DECLARE @idoc INT ;

DECLARE @xml XML = N'

<views>

<view viewName="test_view" viewSequence="1" viewVersion="2.0" viewitem="US" viewStart="2011/02/16 15:00:56:056" viewEnd="2011/02/16 15:00:57:057" viewDuration="00:00:00.5468750">

<viewEvents>

...

TheGrem (3/14/2011)

---

Hi All,

I desperately need help.

I have created a stored proc that retrieves my data correctly from a table. I need to be able to access this data...

Here is some free Video content from some of the best in the biz:

Policy-Based Management

Policy-Based Management Demo

The Import Export Wizard will help you do a simple 'source to destination' data copy, hence the lack of transformation support. It's a shortcut to create a package very similar...

spin (3/14/2011)

---

great, thanks.

I see your point and def don't want to start rolling back transactions. Am i right in thinking that i don't need to worry about this in 2005...

This plus the info from ALZDBA should provide the tools to reach your solution.

DECLARE @ThisDate DATETIME = GETDATE() ;

SELECT

DATEADD(hh, DATEDIFF(hh,...