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.03 seconds.
Search: Posts Made By: jemacc
Forum: Reporting Services June 24th, 2008, 02:47 PM
Replies: 1
Views: 1,883
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,887
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: 921
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,337
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,504
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,707
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,282
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,221
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: 755
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,205
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,575
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: 739
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,604
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,562
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,441
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,888
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: 876
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: 598
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,028
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,060
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: 823
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,299
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,948
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,487
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,347
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 02:48 AM.


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