Viewing 15 posts - 7,936 through 7,950 (of 13,876 total)
SQL.AP (11/9/2015)
One package is calling various child packages. I want to remove any physical dependencies and execute...
November 10, 2015 at 12:47 am
I just created a very simple script component source.
public override void PreExecute()
{
base.PreExecute();
...
November 10, 2015 at 12:43 am
SimonH (11/6/2015)
That's the plan,
However
If a company has a warehouse say in Southampton, and they were sending
packages from Manchester say every day/every hour.
The Manchester and Southampton addresses are going...
November 6, 2015 at 5:16 am
SimonH (11/6/2015)
I Have a table which I've de-normalized for my DimDestinationLocations. see Below

How ever due to the amount of potential repeating rows I'm tempted to
load out the distinct address's into...
November 6, 2015 at 3:42 am
Nice article, Andy.
I assume that you will be adding some parameters to your 'variables and parameters' package in a later article?
Building variable expressions which use the values of parameters passed...
November 6, 2015 at 12:45 am
I appreciate the fact that you took the time to post back with your success story 🙂
And it's great to hear that you were able to build a working solution;...
November 6, 2015 at 12:32 am
ArcticEd32 (11/5/2015)
kaj (11/5/2015)
November 6, 2015 at 12:14 am
JustMarie (11/5/2015)
November 5, 2015 at 1:04 pm
kaj (11/5/2015)
November 5, 2015 at 11:13 am
pshrvankumar (11/5/2015)
TRANIDREVISION FileName JobCode...
November 5, 2015 at 8:47 am
Welcome!
Based on what you have told us, the answer is yes.
But we cannot tell you exactly how without knowing how the database is structured.
Details of guests, periods of stay and...
November 5, 2015 at 8:42 am
Ian C0ckcroft (11/5/2015)
when opening a package i get the error:
Error 5 Error loading 02 04 XLS_GL_Load.dtsx: The connection "NHDQCOG01" is not found. This...
November 5, 2015 at 4:46 am
Try this
if object_id('tempdb..#data', 'U') is not null
drop table #data;
create table #data
(
EQID int
,Revis int
,Filename varchar(20)
,JobCode int
,JobQual...
November 5, 2015 at 1:42 am
Do you get any error or warning messages?
November 4, 2015 at 9:52 am
komal145 (11/4/2015)
I have a script task that reads the variable named"result" ( the stored procedure is ran in execute sql task and stores the result in this variable) and...
November 4, 2015 at 9:51 am
Viewing 15 posts - 7,936 through 7,950 (of 13,876 total)