If I have understood you rightly, then when you call the SSIS Package in a job step. You have a tab there by the name "Execution Options" there you can...

You can try this approach.

ALTER TRIGGER DDLTrigger_Sample

ON ALL SERVER

FOR CREATE_DATABASE

AS

BEGIN

if (select count(*) from sys.databases ) > 9

rollback;

END

Hi,

Check the below code.

DECLARE @CompanyAccountNoVARCHAR(10)

DECLARE @cmd varchar(1000)

DECLARE @ssispath varchar(1000)

set @ssispath = '"C:\program files\Microsoft SQL Server\100\DTS\Packages\SyncOneCompany.dtsx"'

SET @CompanyAccountNo = '2575052'

--select @cmd = 'dtexec /F "' + @ssispath + '"'

select @cmd = '"C:\program...

hmmm, I dont think "hmmm" is right response, but I dont think thats possible to insert " " space in int column, if we have to use a " "...

The below code is self explanatory and that should help, also look out to see for any other responses, there should be easier ways of doing this. I have choosen...

crazekalyan (1/26/2011)

---

UPDATE

DimABCD

SET

ConsumerTypeID = D.Consumertype_ID,

UserID = D.USER_ID

From DimABCD rc

JOIN [bidw].[dbo].[TempConsumer] D ON rc.UID = D.V_ID

here the column UserID(varchar) has empty's in Tempconsumer table. and its an int column in DimABCD...

SELECT RowLength = DATALENGTH(TransRecord), TransRecord

FROM dbo.Staging

If all the rows have Rowlength = 100 then Insert into SQL table else send mail .

How do I do this in ssis.

I am using...

DECLARE @Participants XML

SET @Participants = '<ArrayOfEmployees xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

<Employees EmpID="1" EmpName="abcd" />

<Employees EmpID="2" EmpName="efgh" />

</ArrayOfEmployees >'

SELECT Participants.Node.value('@EmpID', 'INT') AS EmployeeID,

...

Did you try this, first install the sql 2000 related stuff and then on top 2005, generally it...

Good one, the whole BI system is built and you are documenting it now!!! ... Just kiddin

no specific template apart from what is already mentioned above, but make sure...

There is a space in the path of the directory which is the cause for the issue. Get the directory path's in double quotes and run, that would resolve the...

still the same issue, but one thing that we need to remember is that when we add files into the Misc folder, when we are doing a deployment they go...

Couple of things.

Get rid of the primary org temprary table if you can.

Remove the nvarchar max if you do not need it

For CTE, to handle millions of records is...

Check the link, Using Temporary Tables with SSIS, its simple, its just a small trick,

create a global temp table with the required strucutre first.

Set RetainSameConnection=TRUE on the connection manage.

set...

Is there any way to get the work done without needing the permission off dbo on master database. or without having a sysadmin role....

thanks.