April 30, 2015 at 5:26 am
Hi,
Hope I'm in the right forum. Apologies if this is off-mark. I'm a little new to SSIS and need a little help.
I'm reverse engineering some DTS packages from Sql Server 2005 to SSIS in Sql Server 2014. I'm using Visual Studio 2013 now.
I'm including a screen shot of the DTS 2005 package.
I'm making some good progress and have a sequence container that contains 2 database backups processes. I converted that over. Grand so. No probs...
I see the container has an expression icon under it that says: "LEN(@[global::RunId]) > 0" -- not sure what that means? Any suggestions?
Under the expression is an arrow to what looks like a OnPostExecute reporting task that looks like its logging to:
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
at least the path is mapped in the properties anyway so I guess this is what it is doing....
My problem is - in SSIS 2013 I don't know how to set that up! When I create a logging process all I get is an icon under the connection manager area. I suspect strongly that the logging is coupled to that expression in some way.
I'm confused. Can you help me please? I may need a bit of hand holding here....
Thanks,
J.
May 3, 2015 at 3:40 am
jellybean (4/30/2015)
Hi,Hope I'm in the right forum. Apologies if this is off-mark. I'm a little new to SSIS and need a little help.
I'm reverse engineering some DTS packages from Sql Server 2005 to SSIS in Sql Server 2014. I'm using Visual Studio 2013 now.
I'm including a screen shot of the DTS 2005 package.
I'm making some good progress and have a sequence container that contains 2 database backups processes. I converted that over. Grand so. No probs...
I see the container has an expression icon under it that says: "LEN(@[global::RunId]) > 0" -- not sure what that means? Any suggestions?
Under the expression is an arrow to what looks like a OnPostExecute reporting task that looks like its logging to:
D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG
at least the path is mapped in the properties anyway so I guess this is what it is doing....
My problem is - in SSIS 2013 I don't know how to set that up! When I create a logging process all I get is an icon under the connection manager area. I suspect strongly that the logging is coupled to that expression in some way.
I'm confused. Can you help me please? I may need a bit of hand holding here....
Thanks,
J.
This task is simply logging any errors reported by the return code > 0.
😎
Quick thought, I would seriously consider replacing those maintenance plans with Ola Hallengren's[/url] maintenance scripts.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply