ahh, better than what i was trying next, Luis!

i started splitting the all data on CHAR(10), and then splitting whatever had a length that was over @MaxLength ;

i like...

when modified to your example, that's exactly what it does:

/*--results:

TheObjectNameLineNumberLine

Some Comments1ENSURE THE PRODUCT CODE AND BATCH INFORMATION ON

Some Comments2ROUTE CARD IS CORRECT AGAINST THE PICK SHEET &

Some Comments3LABEL

*/

--http://www.sqlservercentral.com/Forums/Topic677895-338-1.aspx

DECLARE @MaxLength int...

Sean pinged me on this one, and i've posted versions of it elsewhere, but i have code saved from other members posts, so let me point you to them.

Lowell (11/13/2013)

---

take...

if Dts.Variables["User::V_FileExistsFlg"].Value is a boolean, you should assign true or false, and not 1, right?

Also,if you append strings like that together, you have to be absolutely sure of ending slashes,...

damnit i was looking for you!

based on some of your comments, i suspected you might be local,...

well, i don't consider TFS to be highly volatile, the developers might have what, a hundred or so check-ins a day?

so this is my default setup for backups:

ALL TFS...

i can tell you how my TFS is setup, and I've had no problems. use that to help make a more informed decision.

my TFS is on a single virtual server...

Jo i use a script task to pull that out for other script tasks to consume all the time..

here's a full script task example, but the piece you need is...

;WITH MyCTE([Bf_ORGN_CD],[LEV5],[BF_ACTY_CD])

AS

(

SELECT 'AC_21234_2','AC_21200_1','402' UNION ALL

SELECT 'AC_21236_2','AC_21200_1','402' UNION ALL

SELECT 'AC_21238_2','AC_21200_1','402' UNION ALL

SELECT 'AC_29000_1','AC_29000_1','802' UNION ALL

SELECT 'AC_29988_1','AC_29988_1','801' UNION ALL

SELECT 'AC_40040_1','AC_40040_1','201' UNION ALL

SELECT 'AC_41061_1','CA_41061_1','207' UNION ALL

SELECT 'AC_41080_1','AC_41080_1','207' UNION ALL

SELECT 'AC_41196_1','AC_41196_1','207' UNION ALL

SELECT 'AC_42404_1','AC_42404_1','801'...

the convert function has an optional parameter when you are converting dates;

112 will give you the eight digit format you are looking for:

SELECT CONVERT(VARCHAR,getdate(),112) --20150803

SELECT Sub_date = CONVERT(VARCHAR,annual_date,112)

coolchaitu (8/2/2015)

---

Lowell Sir,

If these info are not found any books, how does the person who answers the question gets to know such things? Just curious to know. Please share the...

this is usually because the user was once assigned to have a default database that has been renamed or deleted. it's possible that the database exists, but permissions prevent the...

sqlguy-736318 (7/28/2015)

---

My question is more specific: For a given result set in a temp table, will "select top 1" and "delete top 1" operate on the same row in...

SQL does not have anything native to send anything to file.

something external like bcp or sqlcmd, a Common Language Runtime Procedure, Powershell or a proper programming language have the ability...

yeah, i know....

it has a purpose, really!

it comes from a big ol data warehouse db that gets copied once a month.; a previous job step deleted a ton of data,...