Implement a sql query to ssis
up vote
-1
down vote
favorite
I have googled,for along time in order to find solution to implement a sql server query to ssis
SELECT
Sales_Order_Number,company_code,isnull(
(
SELECT
distinct Description + ';' AS 'text()'
FROM
dbo.l_Fact_Orders as xml
INNER JOIN dbo.Tbl_Dim_ItemSOA items ON items.Item_SOA_ID=xml.Item_SOA_ID
WHERE
xml.Sales_Order_Number = myTable.Sales_Order_Number
and xml.company_code = myTable.company_code
FOR
XML PATH('')
)
,'') as Description
FROM
dbo.l_Fact_Orders myTable
GROUP BY
Sales_Order_Number,company_code
I am looking for ideas please.
sql
sql-server ssis edited Nov 22 at 10:44
jarlh
28.2k52137
asked Nov 22 at 10:38
user138957
57115
add a comment |
up vote
-1
down vote
favorite
I have googled,for along time in order to find solution to implement a sql server query to ssis
SELECT
Sales_Order_Number,company_code,isnull(
(
SELECT
distinct Description + ';' AS 'text()'
FROM
dbo.l_Fact_Orders as xml
INNER JOIN dbo.Tbl_Dim_ItemSOA items ON items.Item_SOA_ID=xml.Item_SOA_ID
WHERE
xml.Sales_Order_Number = myTable.Sales_Order_Number
and xml.company_code = myTable.company_code
FOR
XML PATH('')
)
,'') as Description
FROM
dbo.l_Fact_Orders myTable
GROUP BY
Sales_Order_Number,company_code
I am looking for ideas please.
sql
sql-server ssis edited Nov 22 at 10:44
jarlh
28.2k52137
asked Nov 22 at 10:38
user138957
57115
It's unclear what you are asking. Please provide more information about what the actual problem is and what you've tried so far...
– holder
Nov 22 at 11:31
If all you want to do is have that query executed inside of an SSIS package, you can put the query into anExecute SQLtask.
– digital.aaron
Nov 25 at 3:45
add a comment |
up vote
-1
down vote
favorite
up vote
-1
down vote
favorite
I have googled,for along time in order to find solution to implement a sql server query to ssis
SELECT
Sales_Order_Number,company_code,isnull(
(
SELECT
distinct Description + ';' AS 'text()'
FROM
dbo.l_Fact_Orders as xml
INNER JOIN dbo.Tbl_Dim_ItemSOA items ON items.Item_SOA_ID=xml.Item_SOA_ID
WHERE
xml.Sales_Order_Number = myTable.Sales_Order_Number
and xml.company_code = myTable.company_code
FOR
XML PATH('')
)
,'') as Description
FROM
dbo.l_Fact_Orders myTable
GROUP BY
Sales_Order_Number,company_code
I am looking for ideas please.
sql
sql-server ssis edited Nov 22 at 10:44
jarlh
28.2k52137
asked Nov 22 at 10:38
user138957
57115
I have googled,for along time in order to find solution to implement a sql server query to ssis
SELECT
Sales_Order_Number,company_code,isnull(
(
SELECT
distinct Description + ';' AS 'text()'
FROM
dbo.l_Fact_Orders as xml
INNER JOIN dbo.Tbl_Dim_ItemSOA items ON items.Item_SOA_ID=xml.Item_SOA_ID
WHERE
xml.Sales_Order_Number = myTable.Sales_Order_Number
and xml.company_code = myTable.company_code
FOR
XML PATH('')
)
,'') as Description
FROM
dbo.l_Fact_Orders myTable
GROUP BY
Sales_Order_Number,company_code
I am looking for ideas please.
sql
sql-server ssis sql
sql-server ssis edited Nov 22 at 10:44
jarlh
28.2k52137
asked Nov 22 at 10:38
user138957
57115
edited Nov 22 at 10:44
jarlh
28.2k52137
asked Nov 22 at 10:38
user138957
57115
edited Nov 22 at 10:44
jarlh
28.2k52137
edited Nov 22 at 10:44
jarlh
28.2k52137
edited Nov 22 at 10:44
jarlh
28.2k52137
28.2k52137
asked Nov 22 at 10:38
user138957
57115
asked Nov 22 at 10:38
user138957
57115
asked Nov 22 at 10:38
user138957
57115
57115
It's unclear what you are asking. Please provide more information about what the actual problem is and what you've tried so far...
– holder
Nov 22 at 11:31
If all you want to do is have that query executed inside of an SSIS package, you can put the query into anExecute SQLtask.
– digital.aaron
Nov 25 at 3:45
add a comment |
It's unclear what you are asking. Please provide more information about what the actual problem is and what you've tried so far...
– holder
Nov 22 at 11:31
If all you want to do is have that query executed inside of an SSIS package, you can put the query into anExecute SQLtask.
– digital.aaron
Nov 25 at 3:45
It's unclear what you are asking. Please provide more information about what the actual problem is and what you've tried so far...
– holder
Nov 22 at 11:31
It's unclear what you are asking. Please provide more information about what the actual problem is and what you've tried so far...
– holder
Nov 22 at 11:31
If all you want to do is have that query executed inside of an SSIS package, you can put the query into an
Execute SQL task.– digital.aaron
Nov 25 at 3:45
If all you want to do is have that query executed inside of an SSIS package, you can put the query into an
Execute SQL task.– digital.aaron
Nov 25 at 3:45
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
It is bit unclear what you want to do with this query, but I believe that you want to simply get the columns from the query and do something with them?
Drag a "Data Flow Task" to your package
Open the Data Flow, add "OLE DB Source" and click on it
If you haven't created OLE DB connection before, click "New" near the connection manager, otherwise select the connection from the dropdown list
In "Data access mode" select "SQL Command"
Paste your command below
answered Nov 29 at 20:37
Yasskier
406628
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53429065%2fimplement-a-sql-query-to-ssis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
It is bit unclear what you want to do with this query, but I believe that you want to simply get the columns from the query and do something with them?
Drag a "Data Flow Task" to your package
Open the Data Flow, add "OLE DB Source" and click on it
If you haven't created OLE DB connection before, click "New" near the connection manager, otherwise select the connection from the dropdown list
In "Data access mode" select "SQL Command"
Paste your command below
answered Nov 29 at 20:37
Yasskier
406628
add a comment |
up vote
0
down vote
It is bit unclear what you want to do with this query, but I believe that you want to simply get the columns from the query and do something with them?
Drag a "Data Flow Task" to your package
Open the Data Flow, add "OLE DB Source" and click on it
If you haven't created OLE DB connection before, click "New" near the connection manager, otherwise select the connection from the dropdown list
In "Data access mode" select "SQL Command"
Paste your command below
answered Nov 29 at 20:37
Yasskier
406628
add a comment |
up vote
0
down vote
up vote
0
down vote
It is bit unclear what you want to do with this query, but I believe that you want to simply get the columns from the query and do something with them?
Drag a "Data Flow Task" to your package
Open the Data Flow, add "OLE DB Source" and click on it
If you haven't created OLE DB connection before, click "New" near the connection manager, otherwise select the connection from the dropdown list
In "Data access mode" select "SQL Command"
Paste your command below
answered Nov 29 at 20:37
Yasskier
406628
It is bit unclear what you want to do with this query, but I believe that you want to simply get the columns from the query and do something with them?
Drag a "Data Flow Task" to your package
Open the Data Flow, add "OLE DB Source" and click on it
If you haven't created OLE DB connection before, click "New" near the connection manager, otherwise select the connection from the dropdown list
In "Data access mode" select "SQL Command"
Paste your command below
answered Nov 29 at 20:37
Yasskier
406628
answered Nov 29 at 20:37
Yasskier
406628
answered Nov 29 at 20:37
Yasskier
406628
answered Nov 29 at 20:37
Yasskier
406628
406628
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53429065%2fimplement-a-sql-query-to-ssis%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
It's unclear what you are asking. Please provide more information about what the actual problem is and what you've tried so far...
– holder
Nov 22 at 11:31
If all you want to do is have that query executed inside of an SSIS package, you can put the query into an
Execute SQLtask.– digital.aaron
Nov 25 at 3:45