Viewing 15 posts - 556 through 570 (of 623 total)
I need to do this at the db layer because I am tasked with creating a report formatted for Blackberry but I don't have a reporting architecture just SS and...
February 25, 2011 at 1:49 pm
Thanks, this is good information. We do use DTEXEC with the /config switch. I think in my situation the configurations we pass with DTEXEC (dynamic filenames, query criteria) are distinct...
February 24, 2011 at 10:43 am
dndaughtery (2/24/2011)
No my ColA values could be different with more or less distinct values with each execution.
OK, but would the number of sheets or the name of the sheets change?
February 24, 2011 at 10:20 am
OK, but does the destination server and database change for each package. Surely there are a bunch of packages who have the same destinations. They can share the same XML...
February 23, 2011 at 2:15 pm
There can be some properties of a specific package that need to change according to the environment the package is in. If you're going to change the package each time...
February 23, 2011 at 1:15 pm
I'm using C:\SSIS_CONFIG. So yes this will need to be on all production servers, DR servers, and developer workstations.
It seems we have 3 different ideas here:
1) a single xml file
2)...
February 23, 2011 at 8:42 am
Is @pmID just a new id generated from the procedure?
CREATE PROCEDURE MyProc
AS
DECLARE @pmID int
--Here you would call your procedure SP1
--You should post your code here
--The end result is @pmID is...
February 17, 2011 at 8:45 am
Can you just use one procedure?
MyOneproc
AS
DECLARE @pmID int
SET @pmID int =
(Do the logic here that sets the value of @pmID)
--Do your insert
INSERT INTO myTable
SELECT @pmID AS ID,
etc...
FROM MyOtherTable
February 16, 2011 at 10:08 am
Hello,
On question 1 you should find some code examples by searching for 'adParamOutput'.
February 15, 2011 at 9:22 am
See this: http://samuelhaddad.com/2009/03/31/overwriting-an-excel-file-destination-using-ssis/
or search for "ssis excel overwrite" for other solutions.
February 15, 2011 at 9:07 am
Update. We ended up using the Cluster Server Recovery Utility not the plan I outlined at the beginning of the thread. Much simpler.
The help file associated...
February 12, 2011 at 2:37 pm
I meant...
I'm still a little unclear
February 11, 2011 at 2:46 pm
I'm still a little clear about what is happening. It sounds like you have a data file which is being parsed by a pPHPp program. The PHP program generates INSERT...
February 11, 2011 at 2:45 pm
Sorry I misunderstood. I thought your successful INSERT was done entering data directly in the tables in SSMS.
Can you run profiler during during the success and failure and see if...
February 11, 2011 at 1:13 pm
Viewing 15 posts - 556 through 570 (of 623 total)