<div>
You can load through BIDS or Management Studio to upload this file to a SQL Server.<br />
<br />
In managment studio you would need to connect to the Integration Services installation through object explorer. &nbsp;<br />
<br />
View Registered Servers<br />
Click SSIS button (furthest on the right)<br />
Add New -&gt; Server Registration<br />
Add the server with SSIS installed to which you want to upload the dtsx<br />
Once connected you can go to Stored Packages, MSDB, Right Click, Import Package.
</div>


<div>
I have able to import it through SSIS but no idea how to schedule it to run every hours
</div>


<div>
I dont really understands this, OK if I have the file *.dtsx, so I go to sql jobs, create a jobs and integrate with thid *.dtsx file?
</div>


<div>
Ok, I got it..<br />
So how about the integration services which we connect through the SSMS? what will be the use of this services?? as we do a lot of integrations services with BIDS, so when will be this instance is useful for us?<br />
<a href="https://filedb.experts-exchange.com/incoming/2008/07_w29/42208/integration.bmp" target="_blank" class="file-inline" title="integration instance (750 KB)"><svg xmlns="http://www.w3.org/2000/svg" viewBox="0 0 512 512"><path d="M67.508 468.467c-58.005-58.013-58.016-151.92 0-209.943l225.011-225.04c44.643-44.645 117.279-44.645 161.92 0 44.743 44.749 44.753 117.186 0 161.944l-189.465 189.49c-31.41 31.413-82.518 31.412-113.926.001-31.479-31.482-31.49-82.453 0-113.944L311.51 110.491c4.687-4.687 12.286-4.687 16.972 0l16.967 16.971c4.685 4.686 4.685 12.283 0 16.969L184.983 304.917c-12.724 12.724-12.73 33.328 0 46.058 12.696 12.697 33.356 12.699 46.054-.001l189.465-189.489c25.987-25.989 25.994-68.06.001-94.056-25.931-25.934-68.119-25.932-94.049 0l-225.01 225.039c-39.249 39.252-39.258 102.795-.001 142.057 39.285 39.29 102.885 39.287 142.162-.028A739446.174 739446.174 0 0 1 439.497 238.49c4.686-4.687 12.282-4.684 16.969.004l16.967 16.971c4.685 4.686 4.689 12.279.004 16.965a755654.128 755654.128 0 0 0-195.881 195.996c-58.034 58.092-152.004 58.093-210.048.041z"/></svg>integration.bmp</a>
</div>


integration.bmp

<div>
You can store ssis packages inside datase as your image describe, or you can store in the file system.<br />
If you store inside database, is better security and is a better way to organize your packages... but i decide!! :-)<br />
But you must have this service installed if you want to execute ssis packages!!<br />
Cheers!!!
</div>


<div>
I have installed it in FileSystem and create a schedule for it, but the job failed without prompt me any erros? any idea why?
</div>


<div>
Have you tried running the package through Business Intelligence Development Studio.<br />
<br />
You will have to check with the developer on this, as you don't even know if the package they gave you works! &nbsp;It may not have the right connections set up to access the servers.
</div>


<div>
inside SSIS designer goto to SSIS menu and activate SSIS Log Provider to catch the erros of the SSIS package. The job always succeed independent of ssis package succeed or not. You need to create some custom logs or activate SSIS Log provider to understand the cause of the problem!<br />
Cheers!!
</div>


<div>
<div class="content wysiwyg-content">
I have given this file by developer and requested me to upload it, but how can I use SSBIMS to upload and managing this *.dtsx
</div>
</div>


I have given this file by developer and requested me to upload it, but how can I use SSBIMS to upload and managing this *.dtsx

*.dtsx file how to upload it?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.