A big, big SSIS for everything?

Dear all,

I would like to hear point of views, thoughts and ideas about the following request.

As some of us would have seen from a couple a days ago I’ve been setting posts one after one in order to obtain some answers about our business basis.

We’ve got a service running all day long (to accomplish this it was wrote by Visual Basic 6.0) which is checking up a file structure system for a several requirements such a verify if exists a .nul or .txt in each folder and therefore fires a DTS package. Up to here that’s fine, that system works amazing and even is be able to run till three packages at the same time. 400 Dts are scheduled this way and 100 are scheduled by Agent.

Problem comes naturally with SQL2005 where such control is not possible (it seems so) from old tools belonging to Visual Studio 6.0 because the aforementioned version uses assemblies instead of dll, bla,bla.

Keeping in mind that .NET is not possible for reasons that going beyond of any technical matter or whatever I’ve thought do that service by SSIS. A big SSIS running forever. Its responsabilities might be:

1-Look in each folder for the criteria specified in the scheduling of that SSIS

2-Launch a specified SSIS in the case that criteria has matched.

3-Update SQL tables with LOGS, times, executions, etc,

4-Look again

The point 3 will be visible from our Intranet via ASP 3.0 pages as currently we do.

Pros and cons?

Sorry for this painful request but I don’t believe that such issue can be of that kind of odd issues that nodoby suffer in its organizations.

Who else is needed for answers?

Thanks a lot for your time,

I'm not quite sure what your question is. Are you saying you want to run a SSIS package forever that simply keeps looping whenever a file is found? I don't see a problem with that. it would be interesting to see how it goes.

-Jamie

|||

When finds a Jamie.Nul file in d:\server25k\a\ launch SSIS package B and then would delete that .NUL.

Sensible information attached in that SSIS launched as flat file for example, accounts info would be stored in a backup folder. After one execution come back to verify and so on

5 Database Queries to go with an online purchasing system :-)

Hi Guys,

I'm having trouble thinking of ideas for queries that would go with an online purchasing system. The queries must be partially complex (i.e. not just a simple insert query :p).

I can easily write the queries myself but i just need a little help thinking of useful queries.

A query for an 'Invoice' for example is a perfect idea as it implements table joins etc.

Possible other queries are:
Find all customers that have spent a total of more than X amount
Find all delivery address's that X customer has sent items to
Track an order to see if items have been sent yet or not.
etc...

If anyone else can think of a few other ideas i'd be very grateful :-)

thx for reading :-)

--Philkillsonline purchasing sytem? or homework assignment? ;)

total sales by category for the previous month
average price of backlogged orders (product not in stock)
most popular item (by quantity sold, not total price)|||easiest technique...
open a copy of Access, create yuour tables
create the realtionships
open up the query designer
add the required constraints...
run the query, prove it works
open up the query in SQL mode, copy and paste the SQL to your homework assignment paper
...jobsagoodun

... requires minimum thought and creativity, and absolutely no proof that you have understood the concepts behid joins, where clauses etc...|||online purchasing sytem? or homework assignment? ;)

total sales by category for the previous month
average price of backlogged orders (product not in stock)
most popular item (by quantity sold, not total price)

Some nice ideas there thx ^^

easiest technique...
open a copy of Access, create yuour tables
create the realtionships
open up the query designer
add the required constraints...
run the query, prove it works
open up the query in SQL mode, copy and paste the SQL to your homework assignment paper
...jobsagoodun

... requires minimum thought and creativity, and absolutely no proof that you have understood the concepts behid joins, where clauses etc...

and lol...

a nice way to cheat i suppose... but i do actually understand joins etc ;p|||total sales by category for the previous month
average price of backlogged orders (product not in stock)
most popular item (by quantity sold, not total price)
Variations on these:
- Total sales for all foregoing months
- Top ten most popular items
- Most popular category per client (useful for better direct advertising ;-)
- Top ten clients in terms of the amount spent
- Same question, but now in 12 columns, for each of the last 12 months|||- Customer's year to date sales (purchases) compared with last year's year to date sales (purchases).
:shocked:

401 : Unauthorized

Having a hard time finding this one. Have gone as far as having everyone-
full control.
w2k3
rssp2
Any ideas anyone?
System.Net.WebException: The request failed with HTTP status 401:
Unauthorized.
at
System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
methodName, Object[] parameters)
at smarter.ReportService.ReportingService.GetReportDefinition(String
Report)
at smarter.ReportRetrieval.generate_report()I have these problems when the security used in IIS is different from the
caller.
For example, if IIS is configured to Basic authentication, then an NTLM
authenticated user can't access it, and the rverse is possible too.
Also I have this problem with remote access, like the RS utility.
The RS utility works remotly only if IIS is in Basic authentication mode!
in mixed mode (Basic + NTLM) the utility doesn't works.
So, what is your config, and how do you access RS?
custom code? /Reports himself? 2 differents web servers? etc...
"John Holt" <johnh@.regionv.k12.mn.us> wrote in message
news:eP7GLzygFHA.1444@.TK2MSFTNGP10.phx.gbl...
> Having a hard time finding this one. Have gone as far as having everyone-
> full control.
> w2k3
> rssp2
> Any ideas anyone?
> System.Net.WebException: The request failed with HTTP status 401:
> Unauthorized.
> at
> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
> message, WebResponse response, Stream responseStream, Boolean asyncCall)
> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
> methodName, Object[] parameters)
> at smarter.ReportService.ReportingService.GetReportDefinition(String
> Report)
> at smarter.ReportRetrieval.generate_report()
>|||Thanks for the reply Jéjé.
Access RS from a third party app. The app on our web site calls the RS
server passing parameters for the reports. The old RS server works great,
it's just a bit small/slow. I've compared every piece of web and folder
security and they are identical as far as I can see.
Report Manager access is fine. I can do whatever needs to be done in there.
It's just when the app tries to create a report.
I have done this a dozen times and it's usually click, click, boom, boom
your done. I'm low on ideas with this one.:-(
John
"Jéjé" <willgart_A_@.hotmail_A_.com> wrote in message
news:uP6Ep$ygFHA.3256@.TK2MSFTNGP12.phx.gbl...
>I have these problems when the security used in IIS is different from the
>caller.
> For example, if IIS is configured to Basic authentication, then an NTLM
> authenticated user can't access it, and the rverse is possible too.
> Also I have this problem with remote access, like the RS utility.
> The RS utility works remotly only if IIS is in Basic authentication mode!
> in mixed mode (Basic + NTLM) the utility doesn't works.
> So, what is your config, and how do you access RS?
> custom code? /Reports himself? 2 differents web servers? etc...
> "John Holt" <johnh@.regionv.k12.mn.us> wrote in message
> news:eP7GLzygFHA.1444@.TK2MSFTNGP10.phx.gbl...
>> Having a hard time finding this one. Have gone as far as having
>> everyone- full control.
>> w2k3
>> rssp2
>> Any ideas anyone?
>> System.Net.WebException: The request failed with HTTP status 401:
>> Unauthorized.
>> at
>> System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage
>> message, WebResponse response, Stream responseStream, Boolean asyncCall)
>> at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String
>> methodName, Object[] parameters)
>> at smarter.ReportService.ReportingService.GetReportDefinition(String
>> Report)
>> at smarter.ReportRetrieval.generate_report()
>