With the command-line utility "dtexec" of SQL Server 2005. You can execute packages saved as "stored packages" on the SSIS server.
Another way would be execute the package from a local machine, and connect the SSIS data sources to the server of the hosting company
You can use the CASE statement in the ORDER clause
Like this:
ORDER BY CatId, CASE SubCatId WHEN 0 THEN '0' + Description ELSE '1' + Description END
If it doesn't delay too much your query, it would be a solution.
this error may suggest that the problem is that the server don't allow remote connections (By default on SQL Express, for example)
To configure the server to allow remote connections, try this:
Open the surface area configuration tool of SQL Server 2005
On the surface configuration window...
Also you can use the SQL Server 2005 Import Wizard and check the option "Save as SSIS package" at the last step of the wizard.
You can schedule this SSIS package generated by the wizard
The commondialog control of vb, the opendialog changes the current directory. I think is the problem here.
In the commondialog control of vb you can avoid change the current directory with the flags property of the control. (Value = 8), but I don't know if it's applicable on this case
I think you can get the same results without the first sum
Having abs(sum(Case tr.upostdate When convert(datetime,'01/01/#dat1#') then d.samount else 0 End)) +
abs(sum(Case tr.upostdate When convert(datetime,'02/01/#dat1#') then d.samount else 0 End))<> 0
Maybe this pages can help you
How Can I Retrieve Information About the Printer Driver Used by a Printer?
http://www.microsoft.com/technet/scriptcenter/resources/qanda/jul05/hey0719.mspx
How Can I Remove All the Network Printers on a Computer...
It seems like the CDOExm is interpreted like an asp variable
In the CreateObject line. Are you sure that the object is inside quotes?
Set objMailbox = CreateObject("CDOEXM.IMailboxStore")
On the books on line the syntax for the property path is the same that the dtexec utility. (in the command line tab, it generates the command line with the property)
The sintax is:
\Package.Variables[User::Variable].value
http://msdn.microsoft.com/en-us/library/ms162810.aspx
In Microsoft...
You can use the day(date), month(date) and year(date) to get the date without time and the dateadd function to get the previous date.
dateadd("d", -1, date)
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.