Thanks.

Thanks for the info. So the only way to manage frequently used filters is outside of SQL manually and then cut and paste into existing queries or new queries.

I'd define the Midwest states by whatever the company defined them as. Let's say I was a franchise and I was limited so a certain area. Say Indiana, Ohio and...

Maybe I should simplify it. Let's say you need to report on Midwest states in many reports, ETLS, or stored procedures... Would it not be easier to have a vie...

Jeff Moden (1/20/2014)

Actually, from what I saw of the process path in your SSIS graphics and unless...

Thanks for all the tips. But now that I am running the job daily, I can see that it needs to be run serially, since some of the procedures I...

Isn't the code in that link another way of setting a child package...

Being that this is a new problem for me I think I am having trouble grasping your solution. I can't visualize the workflow. I'd prefer to run the packages parallel...

The problem with running them parallel is that I the code I would have to create to solve the problem with creating a signal file when they all are complete....

I saw the same fix at the link you posted:

[highlight=#ffff11]"This irritating error happened again today. I had to copy paste some code from an old package into another. I copied...

Apparently deleting the component and adding it back was the fix. I would have deleted the thread, but I don't see that option.

The problem with running Dtexec three times, assuming you meant having either three steps in a single job or three individual jobs is that the process needs to create a...

I think I will go down the road of one SQL JOB with 4 steps. I have 1 step that needs to run on a certain day of the month,...

from what I am seeing BulkCopy won't work if the procs have temp tables. But I am researching that now. I do have a chunk of procs that don't have...

I ran profiler and got this

exec sp_executesql N'exec [dbo].[usp_EmailNotification]

@msgRecipients = @P1,

@msgSubject = ''General Ledger - Department Integration Failed'',

@msgBody = ''Truncation of the Departments General Ledger Table...