Viewing 15 posts - 211 through 225 (of 580 total)
Use a data conversion transform to change the data type to DT_STR
-Jamie
March 9, 2006 at 2:05 am
Yeah I am. A few comments on it here: http://blogs.conchango.com/jamiethomson/archive/2006/01/08/2586.aspx
-Jamie
March 9, 2006 at 2:03 am
Yeah, Scott is top class. I was in touch with him yesterday to ask him why he's stopped blogging and he muttered something about the american cycling season starting.
March 8, 2006 at 5:46 am
Richard,
Good idea. However I read somewhere recently (darned if i can find where - google hasn't helped) that there is a huge performance degredation when you do that. Generating them...
March 8, 2006 at 5:19 am
A link that will help: http://www.sqlis.com/default.aspx?37
Another one: http://www.sqlis.com/default.aspx?93
-Jamie
March 8, 2006 at 1:53 am
Expressions are the key thing here. If you select any container (containers include tasks by the way) in the control-flow you can press F4 and in the resultant properties pane...
March 6, 2006 at 1:27 pm
ABates,
Encryption options are all to do with the ProtectionLevel property of the package. BOL should help and if it doesn't, reply here.
I've got a bit of info here on storage...
March 5, 2006 at 3:50 am
The method of dynamically setting things like this are through the use of property expressions. There's lots of stuff on my blog about at if you're interested or just reply...
March 4, 2006 at 6:59 am
Set up an agent job to run the package and then execute that job using sp_start_job ms-help://MS.SQLCC.v9/MS.SQLSVR.v9.en/tsqlref9/html/8a91df6a-eb84-4512-9a17-4a6e32a9538a.htm
More info here: http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=257798&SiteID=1
-Jamie
March 3, 2006 at 2:20 am
Monisha,
This question was posed on a SSIS forum yet the article you were directed to was related to DTS so it seems strange that it would work for you.
Are you using...
March 3, 2006 at 2:17 am
Taken from the article linked to above:
"Start by changing to the Operating system (CmdExec) sub-system"
That's what you should use"
-Jamie
March 2, 2006 at 4:30 am
Usman,
Read the article that I linked to above!
-Jamie
March 2, 2006 at 4:04 am
Oh right. Well I do know the answer to this one.
You need a license for every machine on which you install a component of SQL Server. So you won't be able...
March 1, 2006 at 1:33 pm
I am no licensing expert so I can only tell you what we are currently doing. The client I am working for has an MSDN subscription which (I think) means...
March 1, 2006 at 3:42 am
The SSIS server DOES support SSIS instances. Sort of: http://www.sqljunkies.com/WebLog/knight_reign/archive/2005/06/08/15765.aspx
The package executes wherever you call it from. The SSIS server does not execute packages. The package simply executes under...
March 1, 2006 at 2:46 am
Viewing 15 posts - 211 through 225 (of 580 total)