Post Dtsx Packages To Forum

Mar 30, 2007

First off, can you post .dtsx packages to the forum? I always end up cutting and pasting code, which is by is nature incomplete, as it generally has external dependencies (connections, variables).

Perhaps you cannot do so for security reasons?

Second, is there a good blog site that allows you to post .dtsx packages?

I'd rather post .dtsx links than cut and paste code (which half the time formats the code un-recognizably), or even worse, post package xml, which contains the layout information and possibly IL that makes it all but unreadable.

View 4 Replies


ADVERTISEMENT

Problem On This Forum - Deleted Post

Feb 4, 2007

Hello all,

I just got the bellow error twice:
"The post you requested cannot be found or no longer exists. The administrator or moderator may have deleted the post."

Am I the only one that see this? or is it a know problem.

Is there a forum moderator that can check this out (I didn't saw any contect options on this page).

Thanks.

View 3 Replies View Related

Is It Ok To Post A SSIS Contract Vacancy On This Forum?

Jun 30, 2006

Hi,

I wonder if anyone could tell me whether it is acceptable to post a SSIS contract vacancy on this forum?

If not, where would be the best forum/site to find UK-based SSIS developer contractors?

Many thanks,

Gavin.

View 5 Replies View Related

Upgrading System To Run DTSX Packages Instead Of DTS Packages

Aug 2, 2006

Hi all

Our data management system currently runs DTS packages using DTSPKG.dll.

I am currently looking at the possibliity of replacing the DTS packages and SQL 2000 with DTSX packages using SSIS in SQL 2005.

Do I need a new dll? or will the current dtspkg.dll handle the new DTSX packages?

Many thanks in advance!

View 1 Replies View Related

Please Post Setup And Installation Questions In The Setup Forum

Nov 17, 2005

This forum is intended for users who are new to SQL Server, and have basic usage questions. If you have setup or installation issues or questions, you should check out the Setup forum.

Thanks

View 11 Replies View Related

DTS Packages (.dtsx) And Automation Through C#

Jul 23, 2007

I have spent the last couple of weeks going through about 15-20 different examples/tutorials on running DTS packages from inside a C# Windows app (and even asp.net). I must have a mental block, because I can't seem to make it click in my head. I have hundreds of DTS packages saved as .dtsx files. I can double click on them and run them perfectly. What I need to do is be able to run them conditionally from inside a windows app. Could anyone point me to a tutorial or example that could help me with this? I've even looked at some VB source to see if I could work it out, but I keep running up against a wall. I'd appreciate any help anyone can provide.

View 1 Replies View Related

How To Debug DTSX Packages?

Aug 1, 2007

I have some familiarity with DTS packages, and find them easy ( generally) to debug as you can run them step by step and simply find the offending step. when they fail they also put a message box with the error in the centre of the screen. My system has recently been updated and now uses DTSX packages. I can open and veiw these in visual studio, but i cannot run them one step at a time, and they dont give a nice error message when they fail. how do you debug a DTSX package, or at least make debugging it a little easier?

View 7 Replies View Related

DTSX From Deployed Packages

Dec 14, 2007

Hi,

I want to take the backup of all SSIS packages deployed in the SQL server. I need the backup in DTSX format, how should i do that. Please advice.

View 8 Replies View Related

Creating A Package Of Dtsx Packages

Jan 23, 2007

Hi



I am trying to build a package that is comprised of 100+ dtsx packages but cannot seem to get it to work. I have created a new connection where the connectionmanagertype = file and the file path is equal to the folder in which my dtsx files are located. I (location = fileSystem). No matter what I do I get an access denied error that shows the folder location but no package. I manually typed the name of the package in the PackageName property and have pasted in the PackageID in the appropriate property as well but I don't see anything in the PackageNameReadOnly. I have read the MSDN information but I don't see a step by step way to build a package of packages against which I can compare. Can anyone set me straight?



Thanks.

Robin

View 17 Replies View Related

Errors With SQL Cluster Running .DTSX Packages

Sep 25, 2007

I'm experiencing some frustration with my active/passive SQL cluster not running my .DTSX packages. I am hoping someone can shed some light on what I need to do.


I've created some .DTSX packages with the SQL Server Business Intel Dev Studio. I initially built & tested these packages in a non-SQL cluster environment without any problems. I'm now re-creating them to work on our SQL cluster. If I run the package through the Dev Studio it works great.

The packages basically grab .txt files from one of the shared drives (which is a resource of the sql cluster group) and imports the data into the one of the databases. The database does not have any special settings (right-click -> new database... -> enter name -> click ok).


I've setup a SQL Server Agent Job with 1 step with the following properties.
Step name: I Offices
Type: SQL Server Integration Services Package
Run as: SQL Agent Service Account
Package source: File system
Package: G:ImportRAGFLOffices.dtsx


When I run the SQL Server Agent Job through MSSQL Server Management Studio (right-click -> start job) I get an error on "Execute job 'RAGFL TestJob'".


These are the 2 messages that show up when I view the history of the SQL Server Agent job.

***********************************************************************************************
Date 9/25/2007 1:16:13 PM
Log Job History (RAGFL TestJob)

Step ID 0
Server BADBOYS
Job Name RAGFL TestJob
Step Name (Job outcome)
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
The job failed. The Job was invoked by User sa. The last step to run was step 1 (I Offices).
***********************************************************************************************

***********************************************************************************************
Date 9/25/2007 1:16:13 PM
Log Job History (RAGFL TestJob)

Step ID 1
Server BADBOYS
Job Name RAGFL TestJob
Step Name I Offices
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: THEISLANDAdministrator. The package execution failed. The step failed.
***********************************************************************************************

THEISLAND is our internal domain.

View 2 Replies View Related

Best Method For Running/Executing Multiple DTSX Packages?

May 13, 2008

Hello all -

Based on advice from this board, I am setting up our newly-converted DTSX packages (sql server 2000 (DTS) to 2005 (SSIS) package conversion) to utilize package configurations to make it easier to run them in multiple environments (dev, testing, production, etc...). This seems to be working just fine, but I now have another question.

We have approximately 12 DTSX packages which need to be executed in a specific sequential order. I was wondering what the best / most widely accepted method is to allow for running them as an automated process. If you double click on each DTSX file individually, the "Execute Package Utility" pops up, and you can run the package. I'd like to know the best way for us to be able to run each package, one after the other (each one waiting until the previous one completes before it begins), until they have all processed. It would be nice if it did not rely on SQL Server being installed on the machine on which it is being run...

thanks for all the fantastic support on this site

View 6 Replies View Related

Support For SQL DTS Packages Post Upgrade To SQL 2005

Feb 15, 2007

Hi,

I am unclear on Microsofts policy regarding support for DTS and packages that have been imported (but not migrated) to SQL 2005.

The upgrade advisor states
SQL Server 2000 Data Transformation Services   
Advisory   
SQL Server 2000 Data Transformation Services is deprecated  You must completely migrate existing SQL Server 2000 Data Transformation Services (DTS) packages to SQL Server 2005 Integration Services packages before support is withdrawn. 
 
Source Type: MSDB Package
 
What does this really mean?  What will happen to the importing of legacy packages and this whole area within Management Studio? Will these 2005 features no longer be supported? What will happen to the Execute 2000 task?  If I upgrade a SQL 2000 instance post 08/04/08 does this mean that I won't receive support from Microsoft even though the package post installation is in SQL 2005.  Will the new dts designer in the feature pack be taken away/withdrawn?
 
To say DTS packages will no longer be supported is a very dramatic statement with far reaching consequences.  How is this going to be effectively implemented?  Is there really going to be no backward compatibility support in Katmai?
 
Cheers, James

View 2 Replies View Related

Refering To Distinct Values Post(My Other Post)

Oct 22, 2007

---------------------------------------------------------------
My Original Post
I have to query n table(NLRImports) using the Distinct keyword, to retrieve a set of ID numbers. ( "Select DISTINCT id_nbr from NLRImport" ).

Now i want to use those values i retrieved, to process the records in the table(NLRImports) 1 by 1. How do i use those ID no's i retrieved as Variables or parameters for my next query?? If this makes sense?
----------------------------------------------------------------

First, thanks for the response.... now here is what im trying to do.
I created a simple application in delphi to import information to a table in MSSql2005. This is some of the resulting columns...

date | id_nbr | account_nbr | sub_account_nbr | ... etc
-------------------------------------------------------------

Now there will be several entries with the same id no but on different dates, so i take it dates would rather be my pkey.

Then i need to take one person's entries(i work on id_nbr) and go thru all the entries taking the earliest date and comparing all the other entries for that person to the first date and select all the dates more than 19 days after the first date and less than 91 days from first date and place it in a new table.
I used cursor s and while loops to kind of get it going but i know that cursors are not really recommended use but the performance implications dont bother with this particular job.

What other ways should i be using to accomplish this?

thanks, i hope this is clear...

View 1 Replies View Related

DTSX Package Calling Another DTSX Package Question

Jun 13, 2007

I have a dtsx package that is calling another dtsx package, however, if the called upon dtsx package fails with errors or what not, then the calling package does not continue as well. Is there any way to override this such that if the called upon package fails, the downstream actions in that package can stop, but the calling packages downstream actions to continue?

View 3 Replies View Related

Forum Help

Jun 16, 2004

are you able to see the posts in

http://www.dbforums.com/t1001477.html

??

I am seeing a blank page.

View 4 Replies View Related

Forum Recommendation

Sep 8, 2004

Can anyone recommend me other "REALLY GOOD" msql server forums?

Thanks

View 1 Replies View Related

I Hope Its The Right Forum...

Sep 12, 2005

how to use MSSQL in asp.net?

View 2 Replies View Related

Best General SQL Forum

Apr 28, 2008

I'm not impressed with the speed/quality of responses from this forum...

Can anybody recommend a more active forum?

View 20 Replies View Related

Best Way To Design A Forum?

Nov 7, 2007

Hi everyone,

Our company plans to redesign the forum. we currently stores all posts in text files. someone suggest that we can use xml. I am not familiar with using xml. Is XML better for the forum design and data retriving?

Thanks in advance

View 4 Replies View Related

Question About Forum

Jun 6, 2007

Can anyone tell me , For instance : if someone has posted new post and If I want to answer to that post, how can I answer that. Or How do I know that there is some new post which people can response to it, please give me your feed back on this



thank you

View 5 Replies View Related

Msdn Forum

Mar 14, 2008



Where is the list for forums,
When i started to write for Sqlserver, i never searched or looked for forum. Same did when i was working with the c#.
Now I have to find the correct forum. So where is the list of those forums, thanks.

View 3 Replies View Related

This Forum Is BROKEN!!!!

Mar 8, 2007

Anyone having problems with this forum today?

 

I have had countless email alerts thru today alerting me to people replying to threads I have commented on. And I can see the person's comments.

 

1) WhenI click on the link it takes me to a page saying the post doesn't exist

2) When I try and browse to the thread manually I can't see the reply.

3) On one occasion I replied to one of these threads asking if someone had posted something and then deleted it. After I submitted the post I could see all the other posts in the thread which were supposedly missing before. The next time I browse to the thread (in a new browser window) I can't see any of the posts.

 

BROKEN!!!! I for one won't be coming back here until they fix it. Its pathetic.

I have posted something on the bug report forum by the way.

-Jamie

P.S. Its not just on this forum either.

View 8 Replies View Related

Setup Forum?

Apr 27, 2006

Where would I find this. It's not listed under SQL forums. Is this a general setup forum or specific to SQL?



Thanks......

View 1 Replies View Related

Our Forum Has Msgs &&> 8K

Jan 28, 2008

Hi,

Our website provide users with a forum where they can enter messages. So, typically, a user would enter a message, click submit, and their message would be displayed on the forum.

The db that stores these msgs uses a varchar field. Now, we're adding a facility to convert any urls that are entered to links by adding 'a href' tags, so that when users see messages with urls, those urls appear as links, and they can click on them. The problem is that if a user enters a message of 8K chars, then we add 'a href' tags to any urls they have, that makes the message length > 8K, preventing us from storing it in our db. (Please note that we do need to add HTML tags for other reasons as well, not just to convert urls to links.)

We thought about adding 'a href' tags during pre-render, thus avoiding storing html in the db, but found that doing such string manipulations, while a user is waiting to see their post displayed on the forum, was expensive. Timing tests revealed that the time to render such pages more than doubled.

I have solved such problems previously by adding an extra field in the db to store any overflow data, that is, data that appears after the first 8K chars.

However, I learnt of sql server 2005's varchar(max) datatype, and 'am wondering if the best way to solve this problem would be to replace the varchar field with varchar(max).

Thanks in advance for any advice.
Shefali

View 4 Replies View Related

Not Sure If This Is The Correct Forum, But SQL Question

Sep 4, 2007

i have a main pallet inventory table, kinda like:
key        location         sku         qty        datercvd1            W9A03         12345       500      5/5/072            W9A04         12345       500      5/5/073            W9A05         12345       500      5/5/07
Now, if i say:Select loc,sku,qty,datercvdFrom TableWhere sku=12345
it works great, now say my order only requiers 700 of that sku,I only want to pull pallets that i need, how can i say:Select loc,sku,qty,datercvdFrom TableWhere sku=12345 (that qty summed is not more than 700?)
not sure if i can or how to make it like a formula.
Thanks in advance.
Jeff

View 4 Replies View Related

SQL And Forum On Seperate Machines....

Jan 16, 2004

Hi All,

I have got MSSQL 2000 set up on a machine in my rack at my local telehouse, and a web server set up at home on an ADSL line.

Both servers can see (ping) eachother fine , so you can rule out any kind of connectivity issues straight away, but when i try to get my forum to connect to the mssql database using the correct credentials it just fails saying that the credentials are incorrect ot the server does not exist.

I also installed an SQL database tool on my web server (Shusheng SQL Tool) and attempted to connect to my SQL server using that tool, and got the following message: '[DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access denied.'

The server is currently using mixed mode authentication (SQL/Windows) and has both TCP/IP and Named pipes enabled.

Is there some kind of 'Enable remote connections' option in SQL? I need to be able to allow connections to my SQL server from any system, anywhere...

Any ideas?

View 1 Replies View Related

SQL Or Access For A Small Forum

Jan 18, 2004

Hi,

I'm just about to launch a forum, and right now its built in ASP classic with an Access db. I origianlly used Access because most hosts charge extra for MS-SQL server. Recently I switched to Jodohost who offers Access, MS-SQL and MySql for at no additional cost. So now that I have the option, I would like to pick the best solution before I launch.


* My questions are...

- What is the best db solution to go with for a currently small forum?

- How problematic do you think a data migration would be in the future if I stayed with Access for now and upgraded to MS-SQL with a full forum?

- Is it just smarter to go with MS-SQL now, with an empty forum, regardless of any preformance issues because potential migration problems are a greater risk?

- At what point does the speed of MS-SQL at high volumes over come the potential lags in accessing MS-SQL if it is hosted on a different machine from the one hosting the webpages?



* And please keep in mind...

- I have no db training. I can muddle through Access well enough, but administrating MS-SQL I think might be another story

- This fourm will start off very small, but could grow to be quite large

- I may not stay with jodohost, and would therefore likely have to pay more for MS-SQL (which I woudl rather not do)

View 1 Replies View Related

Discussion Forum - Datastructure

Jul 27, 2005

I'm creating a discussion forum for my website, using Sql Server 2000. I need to display 'Number of threads', 'Number of posts', 'Last post by' (username/id and date) for each forum, and 'Number of replies' and 'Last post by' (username/id and date) for each thread.Here are a couple of ideas I have come up with to solve this problem:1) Poll the database (using a stored procedure that returns the number I'm looking for) for each forum when I loop all the fourms. - I suspect this approach isn't optimal, since it creates more traffic to the database.2) Have fields in my Forum and ForumPost tables for 'Number of threads' and so on. Now, create triggers that updates these fields every time a post is made. - I guess this would be much more effective than the first apporach, since everything is done on the database server directly.Are there any other ways that are better? Please advice! Thanks a bunch for any help!

View 7 Replies View Related

Plea To Forum Guardians

Aug 17, 2005

Can you post a FAQ and stop the continuous questions about "login failed"?

View 2 Replies View Related

Is Anyone In This Forum Discussing SQL 2000?

May 22, 2000

I have been helped greatly by people in this forum for SQL7, but I have some questions about 2000. Is this a place where 2000 is being discussed at all? If not I would appreciate someone pointing me in the right direction.

View 1 Replies View Related

SQL Server 2000 Forum

Jan 23, 2001

Looks like there is now a SQL Server 2000 forum for those of us who have been using the 7.0 forum for 2000 questions as the "next best thing."

View 2 Replies View Related

Need Help In Importing Forum Data

Jan 13, 2007

hi,

i am building a forum in asp (just for fun).
i have a mssql 2005 server, and i want to mergeimport data from another mssql 2000 server.
but i dont know how to do it correctly.

i have some tables like this
[forum_c]
forum_c_id (PK, int, not null)
forum_c_name (varchar, not null)

[forum_sc]
forum_sc_id (PK, int, not null)
forum_sc_cid (int, not null)
forum_sc_name (varchar, not null)

etc...

forum_c meaning "forum categories", and forum_sc "forum sub categories".
forum_sc_cid has the value of forum_c_id to know to what categorie it belongs to.

but i dont know how to import it and keep the correct id's.
can somebody please tell me what i need to do???

if you need anymore info to help me just ask.

View 4 Replies View Related

FRx Issue - Sorry If This Isnt The Right Forum

Mar 8, 2007

When running practically any report in FRx (we use it to generate reports in Solomon) we are getting the following error:

FRx Reporting Engine:

01000: [Microsoft][ODBC SQL Server Driver][SQL Server]The statement has been terminated.

This just recently started happening. Is anyone familiar with this? It doesnt give much information after that, it just will not generate the report after the message pops up.

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved