Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Search Forums
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Welcome to the p2p.wrox.com Forums.

You are currently viewing the section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Showing results 1 to 25 of 500
Search took 0.02 seconds.
Search: Posts Made By: jemacc
Forum: Reporting Services June 24th, 2008, 02:47 PM
Replies: 1
Views: 1,835
Posted By jemacc
Did you allow enough space for your image to...

Did you allow enough space for your image to display

Jaime E. Maccou
Forum: Reporting Services June 24th, 2008, 02:42 PM
Replies: 1
Views: 1,846
Posted By jemacc
Have you check your column data type? Jaime...

Have you check your column data type?

Jaime E. Maccou
Forum: SQL Server 2000 June 18th, 2008, 03:07 PM
Replies: 1
Views: 903
Posted By jemacc
Find the block process (select * from...

Find the block process (select * from sysprocesses where blocked=0) find the offending blocker and kill the spid. Log on to your database server --> task manager; end the PID process that correlates...
Forum: Reporting Services June 18th, 2008, 02:25 PM
Replies: 1
Views: 4,243
Posted By jemacc
I do not think it is possible for you to...

I do not think it is possible for you to accomplish this task. You may have to create a custom assembly, then pass the parameters to the assembly, then call the assembly with the parameter in the...
Forum: SQL Server DTS June 4th, 2008, 10:01 PM
Replies: 1
Views: 6,479
Posted By jemacc
What version of sql are you using? this link...

What version of sql are you using?

this link is very old but it may suite your need.
http://www.databasejournal.com/features/mssql/article.php/3462011


Jaime E. Maccou
Forum: SQL Server DTS June 4th, 2008, 09:49 PM
Replies: 1
Views: 1,690
Posted By jemacc
First try converting the excel file to csv file...

First try converting the excel file to csv file tab delimited and run your import

Jaime E. Maccou
Forum: SQL Server DTS June 4th, 2008, 09:40 PM
Replies: 1
Views: 1,267
Posted By jemacc
You can use the FTP Task in SQL Server...

You can use the FTP Task in SQL Server Integration Services (SSIS) Make sure you have service pack 2 as some issues were fixed related to the ftp task.


Jaime E. Maccou
Forum: SQL Server 2000 June 4th, 2008, 09:26 PM
Replies: 1
Views: 1,198
Posted By jemacc
Have you backup the database? are your backups...

Have you backup the database? are your backups failing? What mode you need your on; simple, Bulk-Logged or Full?


Jaime E. Maccou
Forum: SQL Server 2000 June 4th, 2008, 09:23 PM
Replies: 1
Views: 733
Posted By jemacc
What is the dll name? Jaime E. Maccou

What is the dll name?

Jaime E. Maccou
Forum: Reporting Services June 4th, 2008, 03:35 PM
Replies: 0
Views: 1,177
Posted By jemacc
Language settings

I am trying to set a Reporting Services Report that will prompt user for the language use to on the report. Based on the language selected i will like to use the currency for that language.

I...
Forum: SQL Server 2005 December 3rd, 2007, 08:15 AM
Replies: 4
Views: 1,548
Posted By jemacc
You must check your user role and permission,...

You must check your user role and permission, this indicates that you don not have the necessary database credentials and and are not granted those privileges.

Jaime E. Maccou
Forum: SQL Server 2000 November 28th, 2007, 06:27 PM
Replies: 1
Views: 727
Posted By jemacc
Since you are using SQL 2000, this not possible. ...

Since you are using SQL 2000, this not possible. If using SQL 2005 you may have some flexibility by restricting changes to schema and DDL triggers.

Jaime E. Maccou
Forum: SQL Server DTS November 28th, 2007, 06:20 PM
Replies: 3
Views: 6,573
Posted By jemacc
Use the scripting guys at Microsoft ...

Use the scripting guys at Microsoft

http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb05/hey0225.mspx

Jaime E. Maccou
Forum: SQL Server DTS November 28th, 2007, 06:11 PM
Replies: 4
Views: 10,500
Posted By jemacc
wow, this is very old and it has been resolved. ...

wow, this is very old and it has been resolved. Thank you answering.

Jaime E. Maccou
Forum: SQL Server DTS November 28th, 2007, 05:16 PM
Replies: 1
Views: 1,420
Posted By jemacc
You can add an execute task against one of your...

You can add an execute task against one of your connection just as you would execute in QA

Jaime E. Maccou
Forum: SQL Server DTS September 12th, 2007, 04:23 PM
Replies: 1
Views: 1,861
Posted By jemacc
yes, The user must have access to that...

yes,

The user must have access to that database in order to execute the package.

Jaime E. Maccou
Forum: SQL Server 2000 September 12th, 2007, 11:47 AM
Replies: 0
Views: 856
Posted By jemacc
Update one record

Hi all,

I have problem trying to update one record where there may be more than one entry for a given date.

RID EmpID Reason Date
1 2 Good 2007-09-10
2 2 ...
Forum: SQL Server 2000 August 8th, 2007, 08:12 AM
Replies: 1
Views: 580
Posted By jemacc
you can build a database to capture this...

you can build a database to capture this information from profiler then filter based on your needs. You can use reporting services to build reports.

SQL 2005 has a lot of build in reports as...
Forum: SQL Server DTS May 11th, 2007, 11:09 AM
Replies: 2
Views: 1,012
Posted By jemacc
Is the dbase5 db on the server or your...

Is the dbase5 db on the server or your workstation?

you can create a share and point to it using. use the sql task to execute the command to delete the data.



Jaime E. Maccou
Forum: SQL Server DTS May 10th, 2007, 03:41 PM
Replies: 2
Views: 1,045
Posted By jemacc
Have you check if you have a lookup in your...

Have you check if you have a lookup in your transformation?

Jaime E. Maccou
Forum: SQL Server 2000 May 8th, 2007, 01:06 PM
Replies: 3
Views: 802
Posted By jemacc
Try using a sub query similar to this one ...

Try using a sub query similar to this one
SELECT [YEAR]
FROM Table3
WHERE NOT EXISTS
(SELECT *
FROM table2
WHERE table2.pkID = table3.pkid)

Jaime E. Maccou
Forum: Reporting Services May 8th, 2007, 09:16 AM
Replies: 1
Views: 1,281
Posted By jemacc
I am working on a project similar to you ours and...

I am working on a project similar to you ours and my research into this starts here:
...
Forum: SQL Server DTS May 7th, 2007, 08:18 AM
Replies: 1
Views: 1,920
Posted By jemacc
When you run this on your workstation does it...

When you run this on your workstation does it work? It is possible when you schedule it on the server you do not have the excel application and dll's.

Jaime E. Maccou
Forum: SQL Server DTS April 30th, 2007, 10:20 AM
Replies: 2
Views: 3,456
Posted By jemacc
try this site it may...

try this site it may helphttp://www.breakingpar.com/bkp/home.nsf/0/87256B280015193F87256E32007BC6B1

Jaime E. Maccou
Forum: SQL Server 2005 April 25th, 2007, 09:40 AM
Replies: 5
Views: 1,345
Posted By jemacc
Also to Identify orphan user on your database you...

Also to Identify orphan user on your database you can run this script. Please notice table name which stores information related to logins.

CREATE PROC exec dbo.ShowOrphanUsers
AS
BEGIN
CREATE...
Showing results 1 to 25 of 500

 


All times are GMT -4. The time now is 03:08 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.