Hi Sam,

We chose not to use the project model in our projects. We just upgraded from 2005 to 2012 and kept package model.

We didn't see any real advantage of using...

Indeed there is:

SELECT [name] AS SSISPackageName

, CONVERT(XML, CONVERT(VARBINARY(MAX), packagedata)) AS SSISPackageXML

FROM msdb.dbo.sysdtspackages90

where CONVERT(VARCHAR(MAX), CONVERT(VARBINARY(MAX), packagedata)) LIKE '%ActiveX%' --'%sub main()%'

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/70011/

Thank you for confirming this.

Do you know if there is a way to get a list of all packages which have an ActiveX Script Task?

I have hundreeds of packages...

Modify your sp to have a column for Type (dummy).

1) In CR, DB Expert you can reference the stored procedure

2) Add a report parameter.

3) in Selection Expert create...

what kind of report? Crystal? SSRS?

you just create a paramenter, hardcote the values and pass them in?

please be more specific, I don't understand your Q?

something like this.

CREATE PROCEDURE usp_GetT

@Type varchar(16) == import/export

AS

SELECT * from t

WHERE (@Type = 'import' AND Year(@deparr) = Year(t.arrdate))

OR (@Type = 'export' AND Year(@deparr) = Year(t.depdate))

okay, I solved the problem. Step by ste intructions:

1) Drag Drop a Data Flow Task on Control Task

2) Double Click on it and drag a ADO NET Source container

3) Connect...

Ok. I solved the first part: Write into a dynamic file name.

http://www.mssqltips.com/tip.asp?tip=1084

Still having a problem sending dynamic file to FTP server.

Advice?

Thanks.

If I run the query from Management studio logged as a trusted user (for example sa) it runs correctly.

Jeff,

I can run/call the stored procedure from Management Studio and from external application with no problem.

Now I would like to run this stored procedure from within a SQL job....

I ended up using OPENROWSET, like this:

.....

DECLARE @SOIDs varchar(10);

SET @SOIDs = '192502';

-- must use dynamic query because passing params

declare @s-2 varchar(1000)

SET @s-2 = 'SELECT *

FROM

OPENROWSET

(

''SQLNCLI'',

''Database=SLX_EVAL;Uid=someuser;Pwd=pwd;'',

''SET...

No problem, just a preference. Wouldn't be nice when you press T to go to the table name wich starts with T instead of scrolling down 1 tone?

😉

Great article !

But how I would handle if I need to calculate subtotals for the noncalulated fields? For example if you would need to drill down to Customer Type...

here is an article how to add additional rows/columms to a matrix report

http://www.sqlservercentral.com/articles/Reporting+Services/63415/

Excellent! ... so simple!

Thank you!