Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How can I SSIS Concatenate DTS.Variables in Script Task or anywhere? Expand / Collapse
Author
Message
Posted Friday, November 6, 2009 10:00 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Sunday, July 27, 2014 6:10 AM
Points: 4,179, Visits: 4,260
How can I SSIS Concatenate DTS.Variables in Script Task?

sDateTimeStamp = sMonth & sDay & sYear & sHour & sMinute & sSecond

Dts.Variables("DateTimeStamp").Value = sDateTimeStamp

sFilePath = "F:\SQLXXX-S01-BAK-F5a\MSSQLI\Backups\ETL\QQQ_Reports\ADR_BB_J9\Reports\"

sFilePrefix = "ReportsPETS_XX_WW_DailyCount"

sDateTimeStamp = sMonth & sDay & sYear & sHour & sMinute & sSecond

sFileSuffix = ".csv"

Dts.Variables("gsFileName").Value = sFilePath & sFilePrefix & sDateTimeStamp & sFileSuffix

'Dts.Variables("gsFileName").Value = Dts.Variables("gsFilePath").Value & Dts.Variables("FilePrefix").Value & Dts.Variables("DateTimeStamp").Value & Dts.Variables("FileSuffix").Value



For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

Post #815047
Posted Saturday, November 7, 2009 4:47 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 5:27 PM
Points: 1,117, Visits: 2,219
Duplicate post. The question is being answered here.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

Post #815490
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse